What are you using to access the data?
If MS Access for example, you can use the "not in" as part of the query.
The example I have in a book SQL Fundamentals (ISBN 0-13-096016-0) gives the following:
*************************************
select a.number_2,
a.word_2
from twos a
where (number_2 & a.word_2) not in (select (b.number_2 & b.word_2) from twos_modified b);
**************************************
twos = first table
twos_modified = second table
You can also do it using the UNION where you get the data from table1 and then table2 with a text column to show the source, e.g.
*********************************
select number_1,
word_1,
date_1,
'data from first table' as source_of_the_data
from First_table
union
select number_2,
word_2,
date_2,
'data from second table' as source_of_the_data
from second_table
order by number_1;
***********************************
Notes:
only unique records will be in the result and you will be able to see which records are from which table.
both table must have the same data types
Hope this helps.
Noddy