>Hi,
>
>Say, I have two tables in the SQL Server DB. The structure of the tables is the same. And most of the records are the same (my assumption). I want to create a SQL Select that would show me just those rows that exist in one table but do not exist in another table.
>How would you create such a SQL Select?
>
>TIA

Is there a single key column value that's common to both tables as an identifier?