Re: nested select query failing

On Thu, 15 May 2003, [iso-8859-1] SZUCS G�bor wrote:

> Basically, is it true that IN's can be converted to RIGHT JOIN's quite
> simply? Is it always worth?

I'm not sure you want to convert to an outer join (since you want to throw
away the rows on either side that don't match in an IN).  You also have to
be careful not to get duplicate entries from what was the subquery.

As for whether it's worth doing, in 7.3 and earlier, almost
certainly, in 7.4 almost certainly not. :)