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
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.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
