I have 2 tables suppose A and B with some Records Linked on ID some ids are common and some are diff.
I want a flag with values 'A only' , 'B Only' and 'Both in A and B' which filter out the records from both tables based on flag value selected, How can i get that??