> Alan McDonald wrote:
> > best show us your new aliased queries
>
> Here you go:
>
> The statement that is not working with Firebird 2.0.0.12748-0.nptl.i686
> any more:
>
> SELECT a.TYRE_STOCK_LOCATION,a.DESCRIPTION FROM TYRE_STOCK_LOCATIONS a
> WHERE a.TYRE_STOCK = 1 AND a.TYRE_STOCK_LOCATION NOT IN (SELECT
> b.TYRE_STOCK_LOCATION FROM TYRE_STORAGES b)
>
> The statement that is still working with Firebird 2.0.0.12748-0.nptl.i686:
>
> SELECT a.TYRE_STOCK_LOCATION,a.DESCRIPTION FROM TYRE_STOCK_LOCATIONS a
> WHERE a.TYRE_STOCK = 1 AND NOT EXISTS (SELECT b.TYRE_STOCK_LOCATION FROM
> TYRE_STORAGES b WHERE b.TYRE_STOCK_LOCATION = a.TYRE_STOCK_LOCATION)
>
> Sascha

they're quite different queries - you don't expect the same result do you?
Alan