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
