Hi,
If I have 2 tables, and I want to extract the data present only in the Left table exuding the common data based on two columns. How can I do that.
Example:
Table1
PrimaryID SecondaryID
A W
A X
A Y
A Z
B W
B X
B Y
C Y
C Z
Table2
PrimaryID SecondaryID
A W
A X
B W
B X
C Y
C Z
Resultant Table
PrimaryID SecondaryID
A Y
A Z
B Y