Quick and dirty could be: SELECT zip FROM table1 WHERE NOT zip IN (SELECT zip FROM table2)
-----Original Message----- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 16, 2004 4:09 PM To: CF-Talk Subject: Oddball Query question... Odd query question.... MY brain is lagging at 4:00pm... I need some help.... Table one has a list of zip codes. Table two has a list of zip codes. I want to compare table one to table two. The results would list ONLY the zip codes that appear in table one that do not appear in table two. Any help is greatly appreciated... Thanks, Jeff ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184475 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
