I am wondering how to make a query between two tables, which each contain a serialnum column. In plain English I would describe the query as...
select records from table1
where there is a serialnum that is not present anywhere in table2
Can anyone help me this?