• Without the join, the except statement would also return rows in the source that do not exist in the target as well as those that exist (by id) in both sets but are different.

    What I needed was to determine differences between rows that exist between both sets, but have differences.

    Having a series of tables with 100, 200+ columns to compare is asking for human error, especially when nulls need to be taken into account.