I have two tables in SQL Server database. These tables have the same columns, we can say it's a copy - I use one for Archive data and the other for current use of data.

The Archive table doesn't have a primary key because sometimes there can be repetition, and sometimes the primary key may be found in the current table and a copy in Archive table.

I would like a `SELECT` statment to count the number of columns from the two tables without counting repetition of the primary key, because the primary key in the first table may be found two times or more in the second table.