wouldn't this be an OUTER JOIN LEFT? v/r, Jeff
-----Original Message----- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Friday, April 26, 2002 8:49 AM 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
