Thank you all. The world makes sense again. :)
Larry S. Brown
Dimension Networks, Inc.
(727) 723-8388
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 10:54 AM
To:
[EMAIL PROTECTED]
Cc: MySQL List
Subject: Re: unexpected results from
You are using the wrong syntax, try
SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id WHERE
table2.id IS NULL;
The query, you are using produces cross join while you need to implement
left join for your problem.
Enjoy
Nitin
- Original Message -
From: "Larry Brown" <[E
The simple JOIN (which is what you have requested with the A, B syntax)
builds a conceptual table in which every row in A is paired with every row
in B, then passes the result on to the WHERE filter. Of course, it doesn't
actually do that, because it would take an enormous time, but it mimics
that
You need a LEFT JOIN
"select f.controlnum,f.referencenum,f.fname,f.lname from first f,
left join second s on f.controlnum = s.controlnum
where s.controlnum IS NULL and f.inputtime > '07:00:00'"
Larry Brown wrote:
ok, now I want to run a query that results in all of the controlnum's in
table on
