Hi Guys I am trying to display 1 random record taken from 2 tables.
I have tried the following; SELECT table1.record1, table1.record2, table2.record1 FROM table1, table2 ORDER BY RAND() Limit 1 With no luck... So now I am trying to use CREATE VIEW but also with no luck... Can anybody help out? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
