Alexandre Benson Smith wrote:

> I understood what you want.. but really don't get why diferent results
> :-( For sure we are missing some obvious point.

That's what I'm trying to find out.

> In fact I expect the both queries to have the same plan, and that the
> optimizer will transform internally the latter into the former (at least
> it will do it for IN, I expect the same for NOT IN).
>
> Could someone shed some light on this ?

Let's not dig too deep into the technicalities here, because my problem
is not on FB (it's on SQL Server 2000). I asked a generic question about
SQL here because I know a lot of people here are very good at SQL.

I wanted to make sure there's not something obvious I'm missing before I
conclude that there's a (rather dangerous) bug in SQL Server. If I have
time I'll give it a try on FB.

Thanks,
Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64