You can scan through one table and see if the other one has those rowids or
not.
On Thu, Mar 10, 2011 at 8:08 PM, Vishal Kapoor
<vishal.kapoor...@gmail.com>wrote:
> 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
>
