Home Forums Article Discussions Article Discussions by Author Discuss content posted by Gary Chinn Select unmatched data from two columns RE: Select unmatched data from two columns

  • November 25, 2012 at 8:27 pm

    #1562067

    I like this way of expressing the solution:

    SELECT t1.ID FROM dbo.T1 AS t1

    UNION

    SELECT t2.ID FROM dbo.T2 AS t2

    EXCEPT

    SELECT t1.ID FROM dbo.T1 AS t1

    INTERSECT

    SELECT t2.ID FROM dbo.T2 AS t2;

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi