I have a unique request. I must do a comparison on the db side of 2 or more result sets, and locate only the rows that have matches in other datasets being compared.
In summary, I will have for example, 3 sets as shown below:
......So from the above, I want to return ONLY "7777" and Compare Test as below:
That's all I want (only the common rows amongst all the datasets that I am comparing). Surely this is possible, no? (also- I must be able to support dynamic numbers of datasets to be compared (sometimes it will be 2- sometimes it may be 20).
This is a tough problem (for me!); any help or pointers you provide are greatly, greatly appreciated.
Thanks to all in advance!