are you trying to get emails from table 1 that are not in table 2? if so use a WHERE NOT EXISTS clause "W Luke" <[EMAIL PROTECTED]> wrote: > I'm gusing you want something like this: > > A > B > 1 > 2 > 3 > > right? I think so...for example, here's the problem I'm faced with: TABLE 1 TABLE 2 --------- ---------- [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] What I need to return is: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] Each table has 1600-2000 member address from my site, and even at a glance I can see lots of duplicates, making it 8000 at least. How can I do this? Cheers Will ~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
