sql query help
Posted: Tue Feb 15, 2005 7:17 am
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???
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???