hi.
a join across 3 tables with 2 records each will return 8 rows...2*2*2 = 8.
hth.
-ravi.
-----Original Message-----
From: Fates [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 9:38 AM
To: [EMAIL PROTECTED]
Subject: Output from select is not what expected
I have three tables in a database called menus and I have added 2 records
to each table so 2*3=6 records. Why is it when I do a "select * from
table1, table2, table3" I get 8 records back when there are only 2 records
in each table? What am I doing wrong? Some of the fields are references
if that makes a difference? I want to list the output from all tables
together.
Using Latest MySQL RedHat Linux RPM
--
This email was sent using w3mail.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
