Hello list, i still need a solution for my 3 table join rand problem, im using version 4.1 now so subqueries are possible:
explanation: i have 3 tables lets say: fruits: id, name 1 banana 2 apple 3 strawberry fruits_animals id, id_fruits, id_animals 1 1 2 2 1 3 3 3 1 4 2 4 animals id, name 1 cat 2 dog 3 mouse 4 elephant My problem is that if i join the tables and order them by rand i always get one result something like: strawberry, cat (fruit id = 3, animal id = 1 ) or banana, dog (fruit id = 1, animal id = 2) but never banana, mouse( fruit id = 1, animal id = 3 ) and need to select 100 different relations without redundancies hows that possible ? regards sebastian gerske -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]