- 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
from more than 1 table
- 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
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?