Using where not exist

[Anonymous]

Hi There,

How to find the differences in a column (similar) between 2 tables.

Example: There are 2 tables (Fact1 and Fact2), each containing a common field called "ID". I want to find out which values do not exist in Fact2.

Desired Result - "B" and "C"

I

Thanks,

[MarcoWedel · Accepted solution]

see your other thread regarding this topic:

List difference / delta between 2 columns in 2 different tables in load script

hope this helps

regards

Marco