Hello list, im having a hughe problem with the RAND() function
first of all im using mysql 3.23 so subquerys are impossible. Im having three tables which are joined by ID's now i want to select a single row random out of the join set whats the best way to do it? My Table structure is: 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 | ----------------------------------------------------- and so on .. 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]