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 that are not in table two.  The query I ran was "select
f.controlnum,f.referencenum,f.fname,f.lname from first f,second s where
f.controlnum != s.controlnum and f.inputtime > '07:00:00'"






-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to