You can write this query using NOT IN operator
> -----Original Message----- > From: Joshua Tipton [SMTP:[EMAIL PROTECTED]] > Sent: Friday, April 26, 2002 6:19 PM > To: CF-Talk > Subject: SQL Query > > I need this query to pull the reg_no, dis_no, m_id, and the y_id from > tbl_CTMCORPMONTHYEARRDD where it cannot be found in pagan table. I wrote > this query and cannot get it to work please help. > > Josh > > > SELECT tbl_CTMCORPMONTHYEARRDD.reg_no, > tbl_CTMCORPMONTHYEARRDD.dis_no, > tbl_CTMCORPMONTHYEARRDD.m_id, > tbl_CTMCORPMONTHYEARRDD.y_id > FROM tbl_CTMCORPMONTHYEARRDD INNER JOIN > pagan ON > tbl_CTMCORPMONTHYEARRDD.m_id <> pagan.m_id AND > tbl_CTMCORPMONTHYEARRDD.y_id <> pagan.y_id AND > tbl_CTMCORPMONTHYEARRDD.reg_no = pagan.reg_no AND > tbl_CTMCORPMONTHYEARRDD.dis_no = pagan.DIS_NO > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists