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???
sql query help
Moderator: General Moderators