SQL Server Select Query to exclude records based on values from lookup file.
Posted on 2014-01-21
This should be a pretty easy one. I just need a SQL Select query that will exclude records based on a value from a look up exclusion file. There are two files; the primary file called addresses and the lookup file called "Keywords" which contains one column called keywordvalue. If the OWNER column from the "Addresses" file contains a value from the keyword file it needs to be removed. Ideally, I would like the removed records to be put into a separate file but I am not sure if that is possible.
Addresses File: Keyword File:
Keyword File Example: