- 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
). In that case, please post
your version and maybe someone else can suggest something that would work
for you.
Rhino
- Original Message -
From: Christian Biggins [EMAIL PROTECTED]
To: 'Rhino' [EMAIL PROTECTED]
Sent: Friday, January 14, 2005 11:43 AM
Subject: RE: Selecting a random record
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?
On the site Adoption.com we have been using a mysql database to set up
families who want to adopt. We have since redesigned our site and the old
code is not working for us. I am trying to design a section of code in ASP
to connect to the database and return a random record. Here is what I
PROTECTED]
Subject: FW: Selecting a random record
Any idea why I get this error when I try to create this table
on a clean
3.23.30 install on a BSDI box.
This was the output from a mysqldump from version 2.22.32 on a working
database. It will not allow me to recreate my database on the
n