On Sun, 20 May 2001, Don Baccus wrote:
> At 10:55 AM 5/20/01 -0700, Stephan Szabo wrote:
> > Can the IN always get written as a
> >join and is it always better to do so?
>
> Nope:
> ...
> A better question, I guess, is if it is always better to write
> it as a join if the left hand operand is a table column and
> the right hand operand a rowset.
Well I was assuming we were talking about the subquery case
in general :)
It might be a problem with subqueries with set value functions
and parameters passed down from the outer tables:
select * from blah whereblah.val1 in (select count(*) from blah2 where blah2.val2=blah.val2 group by blah2.val3);