How can I compare rows from 2 tables that have composite primary keys?

Posted by cdeszaq on Stack Overflow See other posts from Stack Overflow or by cdeszaq
Published on 2010-03-12T20:59:57Z Indexed on 2010/03/12 21:07 UTC
Read the original article Hit count: 173

Filed under:
|

Here's the scenario:

I have 2 tables with data, one is the 2009 version and the other is the 2010 version. The primary key for each of the tables is a composite key. I know there is a different number of rows in each one and I need to find out the differences.

Typically, in the "normal" primary key set-up, I would just look for primary key values NOT IN the list of primary keys from the other table. But I don't know how to do this with a composite primary key (or even if it's possible).

So, how can I compare the rows from these two tables?

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server