Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Most efficient way of not selecting data RE: Most efficient way of not selecting data

  • May 2, 2018 at 12:37 pm

    #1988985

    Your query just needed aliases. 
    A fixed version, along with an alternative which may perform better (you should test, of course)

    SELECT * FROM #tblContacts c
    JOIN #tblEmails e ON c.ContactID = e.ContactID
    WHERE e.EmailAddress NOT IN (SELECT EmailAddress FROM #tblNoEmail)

    SELECT * FROM #tblContacts c
    JOIN #tblEmails e ON c.ContactID = e.ContactID
    WHERE NOT EXISTS (SELECT 1 FROM #tblNoEmail ne WHERE ne.EmailAddress = e.EmailAddress)

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.