SELECT * FROM TableOne ; UNION ; SELECT * FROM TableTwoIf your new RecCount() is the same as either of your source tables then the tables are identical. If the RecCount() has increased then you have rows with differences. All you need to do is select those rows with the same primary key. This assumes that the primary key has not changed - only the (other) data.