"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]