On 11/30/10 5:54 PM, Kevin Grittner wrote:
> "T.H."<calinet6@gmail.com> wrote:
>
>> Also, are there any better ways you can think of doing such an IN
>> query, using non-subselect means that might be more efficient?
>
> Have you tried the EXISTS predicate?
>
> -Kevin
>
Just looking into it now, thanks for the suggestion. Is there a reason
that EXISTS is generally faster than IN for this sort of query?
-Tristan