help me please :/
""Gerske, Sebastian"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > 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]
