And here is a sample of my Reference Table:
GroupID SubGroupID ABC RRR ABC SSS LMN TTT XYZ BBB
Basically, what I am looking for is new instances of records where the GroupID already exists in my Reference table, but the SubGroupID does not.
GroupID SubGroupID ABC RRR XYZ BBB XYZ CCC
because that is the only record where the GroupID already exists in my Reference Table, but the SubGroupID (of "SSS") does not.
GroupID SubGroupID ABC SSS
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!