Subject How to compare two tables?
Author Marco Menardi
Hi, is there a "clever" sql way to compare two tables?
Put that table A and table B have this structure:
I want to find:
a) if A has EMPLOYERS (records) that B misses
b) if B has EMPLOYERS (records) that A misses
c) if an employer in A table has a different salary than the same has
in B table (an vice versa, but seems not necessary to check ;))

Marco Menardi