t;
> Christian
>
> -Original Message-----
> From: Rhino [mailto:[EMAIL PROTECTED]
> Sent: Saturday, 15 January 2005 12:56 AM
> To: Christian Biggins; mysql@lists.mysql.com
> Subject: Re: Selecting a random record from more than 1 table
>
>
> - Original Message -
- Original Message -
From: "Christian Biggins" <[EMAIL PROTECTED]>
To:
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
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?
