Hello list, im having a hughe problem with the RAND() function
first of all im using mysql 3.23 so subquerys are impossible. table1 --------------- | id | content | | 1 | apple | --------------- relation_table ---------------------------- | id | id_table1 | id_table2 | | 1 | 1 | 1 | | 2 | 1 | 2 | ---------------------------- table2 ------------- | id | content | | 1 | bear | | 2 | ape | ------------- The result should be somehting like: Query1 (randomly generated): ------------------------------------------------------ | table1.id | table1.content | table2.id | table2.content | | 1 | apple | 1 | bear | ----------------------------------------------------- or Query2 (randomly generated): ------------------------------------------------------ | table1.id | table1.content | table2.id | table2.content | | 1 | apple | 2 | ape | ----------------------------------------------------- thanks for comments / suggestions / solutions -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]