At 04:47 PM 2/11/2003 -0600, Dina Hess wrote: >Have you tried this? > >select * >from table1 LEFT JOIN table2 ON table1.id = table2.id >where table2.id IS NULL
I think I love you. :) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Get the mailserver that powers this list at http://www.coolfusion.com
