----- Original Message ----- From: "Christian Biggins" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Friday, January 14, 2005 12:07 AM Subject: Selecting a random record from more than 1 table
> 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? > Your question isn't very clear; I can't make out what you are trying to do. Can you explain in a bit more detail? It sounds like you are trying to do a join of two tables which selects all records from both which match and then choose one of the resulting records at random. But, if that is true, your query contains a bad join because it is actually going to join every row of Table1 with every row of Table2 *even if they haven nothing in common*. I'm not sure why you want to create a view either. Also, what version of MySQL are you using? Some things can't be done at all in some versions of MySQL.... Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
