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
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 one
: unexpected results from query between tables
|
--|
I apparently am misunderstanding how the select works
[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 have used a similar statement to the one that
follows
: unexpected results from query between tables
|
---
---|
I apparently am misunderstanding how the select works by referencing data
in
two different tables. I have used a similar