Page 1 of 1

sql query help

Posted: Tue Feb 15, 2005 7:17 am
by gurjit
hi all,

easy but i'm having a bad day.

I have two tables. one has less records than the other, the tbl_enquiry_now has less records than tbl_enquiry. I want to find the missing records in tbl_enquiry_now.

I tried this
SELECT DISTINCT (tbl_enquiry.eqid)
from tbl_enquiry_now,tbl_enquiry where tbl_enquiry.eqid != tbl_enquiry_now.eqid order by tbl_enquiry.eqid

but it dont work...any ideas???

Posted: Tue Feb 15, 2005 7:56 am
by feyd
check the Useful Posts thread.