Finding non-duplicate records?

From: Billz89 (Billz89_at_discussions.microsoft.com)
Date: 06/15/04

  • Next message: Rohtash Kapoor: "Re: Finding non-duplicate records?" 
    Date: Tue, 15 Jun 2004 09:08:02 -0700

    Hello.

    I have two tables and in each e-mail addresses; one for newsletter subscribers, the other for contest entrants. I want to send a special one-time-only newsletter to the contest entrants who are not subscribers of our newsletter. I have been able to pull the duplicate records for the tables, now I just need to pull the non-duplicate e-mails from the contest table. I tried this:

    SELECT Contest.EMAIL AS Expr1
    FROM Contest CROSS JOIN
                          NewsLetter.dbo.pgd_Members
    WHERE (NOT EXISTS
                              (SELECT EMAIL
                                FROM Contest
                                WHERE NewsLetter.dbo.pgd_Members.Email = Contest.EMAIL))

    I created the above based on research I did in this forum, but I did something wrong as the query is stuck in a loop. I stopped at over 1 million rows. The Contest table has 4,000 records.

    Thanks for the help.

    Bill

  • Next message: Rohtash Kapoor: "Re: Finding non-duplicate records?"

    Relevant Pages

    • Re: To Crosstab or not to crosstab
      ... Duane Hookom ... MS Access MVP ... Remember I want Expr1, Expr2... ... to be values in the crosstab query ...
      (microsoft.public.access.queries)
    • Re: Forum Etiquette
      ... I?ve been querying for solutions to some problems I have been having, ... I appreciate this forum is oversubscribed and contributors must feel ... of a query, bearing in mind that others are going to come along wishing to ...
      (microsoft.public.windowsxp.general)
    • Re: Line Numbering
      ... EXPR1: SELECT expression1, expression2 ... returns 2 expression into ONE field, EXPR1. ... ToteNumber OrderNumber LineNum ... When I try to run the query, I get the error message that I am missing ...
      (microsoft.public.access.queries)
    • Re: Append query with addtional fields
      ... Expr1: isIncrement ... it doesn't matter which field you use in the function argument, ... for the whole append action, which is what was happening in your query. ...
      (microsoft.public.access.queries)
    • Re: Append query with addtional fields
      ... Expr1: isIncrement ... and put the following function in a standard module, ... which is what was happening in your query. ... I can't quite figure out how to increment the numbers in the field. ...
      (microsoft.public.access.queries)