The NC_MC tables are going away. But I got it figured out. The dev database was corrupt. Created a new one and it worked fine.
-----Original Message----- From: joe [mailto:[EMAIL PROTECTED] Sent: Monday, April 30, 2007 9:52 PM To: SQL Subject: RE: Sub Query Proboblem At a glance this looks wrong "tblCurrentCouncilMembers.Member_ID = NC_MC.DONE_ID" Unless Member_ID is truly = to DONE_ID at which point I would rename the "NC_MC.DONE_ID" to "NC_MC.Member_ID" ----hope this helps ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2833 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
