Home Forums SQL Server 2012 SQL Server 2012 - T-SQL t-sql 2012 want 'NOT in' or 'NOT EXISTS' to work RE: t-sql 2012 want 'NOT in' or 'NOT EXISTS' to work

  • July 17, 2016 at 12:39 pm

    #1890492

    I could rewrite the code this way...

    SELECT personID

    FROM #gradPerson AS g

    WHERE NOT EXISTS (SELECT TC.PersonID

    FROM TranscriptCourse AS tc

    WHERE tc.PersonID = g.PersonID

    Are you saying you don't understand what an alias is? I'm creating aliases to #gradPerson and TranscriptCourse so that I can join them in the correlated subquery... you just set the PersonID of the subquery (tc.PersonID) equal to the same field in the outer query (g.PersonID).