Hi,

I have two almost identical sets of records, what would be the most efficient way of detecting records that are different in the table based on a single column?

This is a snapshot of the data I am looking at:

Master Table

16777216 16777471 AU Australia
16777472 16777727 CN China
16777728 16778239 CN China
16778240 16779263 AU Australia
16779264 16781311 CN China
16781312 16785407 JP Japan
16785408 16793599 CN China

Secondary

16777216 16777471 AU Australia
16777472 16777727 CN China
16777728 16778239 CN China
16778240 16779263 AU Australia
16779264 16781311 CN China
16781312 16785407 JP Japan
16785408 16793599 JP Japan

In the example above the last record in secondary table is different so this is the only row I would like to return, if that makes sense.

Any help appreciated.

regards

Si