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