Friends, how do I best achieve intersection of sets of row ids suppose I have two tables with similar row ids how can I get the row ids present in one and not in the other? does things get better if I have row ids as values in some qualifier/ qualifier itself? I hope the question is not too confusing...
intersection of {1, 2, 3} and {2, 3, 4} is {2, 3}. while {1,2,3} are row ids from a table, {2,3,4} may come from other table as qualifiers in some row. thanks, Vishal