sql query help

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
gurjit
Forum Contributor
Posts: 314
Joined: Thu May 15, 2003 11:53 am
Location: UK

sql query help

Post 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???
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

check the Useful Posts thread.
Post Reply