Help with a query RSS

• • Reply
  

  mullsey

  0 Points

  2 Posts

  Help with a query

  Mar 28, 2012 07:36 AM|LINK

  Hi,

  I hope someone can help with this.

  What I am trying to do should be fairly simple I think.

  I have a list of email addresses that have unsubscribed from my mailing list.  I have put these into a table.  I have another table which I add new contacts to.  What I want to be able to do is create a query that joins the email address from my master list to the email address in my unsubcribe table.  I want to return all rows from the master list except those that exist in the unsubscribe list.

  Can anyone please give me some ideas on hot to do this.

  Thanks

• • Reply
  

  Vipindas

  Contributor

  5514 Points

  810 Posts

  Re: Help with a query

  Mar 28, 2012 07:49 AM|LINK

  SELECT [Email]
    FROM [EmailMaster]
  Union
  SELECT [Email]
    FROM [Unsubscribe]

  Hope this helps...

  Please remember to mark as answer if it helps you
• • Reply
  

  waelouf

  Member

  250 Points

  41 Posts

  Re: Help with a query

  Mar 28, 2012 07:51 AM|LINK

  select mail from masterTable where mail not in (select mail from unsubcribeTable)

  
  
  

  
  

  This is it :)

  • Marked as answer by decker dong - msft on Mar 30, 2012 01:23 AM
• • Reply
  

  mullsey

  0 Points

  2 Posts

  Re: Help with a query

  Mar 28, 2012 08:46 AM|LINK

  many thanks