"MySQL List" <[EMAIL PROTECTED]>
|
| cc:
|
| Subject: unexpected results from query between tables
|
>---
---|
I apparently am misunderstanding how the sel
Brown" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, October 27, 2003 8:54 PM
Subject: unexpected results from query between tables
> I apparently am misunderstanding how the select works by referencing data
in
> two different tables. I ha
|
| cc:
|
| Subject: unexpected results from query between tables
|
>
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
I apparently am misunderstanding how the select works by referencing data in
two different tables. I have used a similar statement to the one that
follows with success, but there must be something different here that
reveals a lack of fundamental understanding as to how it works. If someone
could
