Hello,
How can I return records from table-1 that do not match with records in table-2?
I have a master table (say Table-1) that contains all the data. Another table (Table-2) contains records that I do not want to see in the resulting table.
I need to do following:
(Table-1) - (Table-2) = Query result set.
There is a report that I have created; as the project proceeded I was asked to enter some exceptions (records that we do not want to see in the result set). So I hard coded those exceptions in my SQL query. I am thinking of creating an exceptions table to which I can add or remove exceptions without having to edit the code.
Could anyone please guide me to which approach should I follow.
Regards,
Rajesh
How can I return records from table-1 that do not match with records in table-2?
I have a master table (say Table-1) that contains all the data. Another table (Table-2) contains records that I do not want to see in the resulting table.
I need to do following:
(Table-1) - (Table-2) = Query result set.
There is a report that I have created; as the project proceeded I was asked to enter some exceptions (records that we do not want to see in the result set). So I hard coded those exceptions in my SQL query. I am thinking of creating an exceptions table to which I can add or remove exceptions without having to edit the code.
Could anyone please guide me to which approach should I follow.
Regards,
Rajesh