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"
see your other thread regarding this topic:
List difference / delta between 2 columns in 2 different tables in load script
hope this helps
Retrieving data ...