This is a common join issue. If you don't specify ANYTHING to connect
between the two tables, it'll do one row from the first table, then ALL
the rows from the second. Row #2 from the first, then ALL the rows from
the second.
If you had 600 rows in each table, you'd end up with 360,000 rows as
-Original Message-
From: Chip Wiegand [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 11, 2004 3:28 PM
To: PHP DB
Subject: [PHP-DB] query of two tables returns too many rows, many more
than the two tables contain
I have two tables I want to get out the rows that are different between
Gryffyn, Trevor [EMAIL PROTECTED] wrote on 11/11/2004
01:39:37 PM:
This is a common join issue. If you don't specify ANYTHING to connect
between the two tables, it'll do one row from the first table, then ALL
the rows from the second. Row #2 from the first, then ALL the rows from
the