Hi,
It seems like you are not "joining" the tables in any way. Say you have:
Table1 --- record1_id = 1 --- record2_id = 2
Table2 --- record1_id = 3 --- record2_id = 4
Table3 --- record1_id = 5 --- record2_id = 6
If you do a select all, you get all permutations:
1, 3, 5
1, 3, 6
1, 4, 5
1, 4, 6
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
Because 2*2*2=8.
You need to put joining information in the where clause.
I suggest you get a book on SQL.
You might try "MuSQL" by Paul DuBois ( New Riders).
Fates wrote:
>
> 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
