How to eliminate Keys from two seperate tables

[#1]

I have TableA with an Order Name field, ProviderName, and ProviderNameKey, which I am eliminating certain Order Names in my qvd creation.  I have another TableB that also contains the ProviderNameKey field that I have created a seperate qvd for.  How do I go about eliminating the same ProviderNameKey's in TableB that are eliminated in TableA?  Would I concatenate the tables?

[giakoum · Accepted solution]

Hi.

you should left join them having as second table the one with the values you need to keep.

or

you could also use something like LOAD * FROM TableB WHERE EXISTS(KeyField)

giakoum

[#3]

Left Join was the way to go.  Thank you.