SQL query with unique keys between two tables

[eluser]davidbehler[/eluser]
You could use a union to do so.

In your example it would be something like:

Code:

(select id from table1)
union distinct
(select id from table2);

And then just count the number of rows you get returned.