--- In firebird-support@yahoogroups.com, Pavel Menshchikov
<mpn2001@y...> wrote:

> You could try the following also:
> -----
> SELECT
> orders.orderno,
> orders.ordertitle
> FROM
> orders
> WHERE
> NOT EXISTS
> (SELECT
> 1
> FROM
> bills
> WHERE
> bills.bill_reference = orders.orderno)
> -----

This - in our very special case - works about 10% FASTER than the
left-outer-join/right-side=null method.
(... and slap me again, because something like this I could have found
in Helen's book...)

spasiva!
André

> HTH
> --
> Best regards,
> Pavel Menshchikov
> http://www.ls-software.com

I was looking at your site, btw., I will try to test the software
during the next 4-6 weeks, because we plan to implement something
similar in our company.
If you do not hear anything from me until then, drop me a note at
knappstein$NoSpam$at$beta-eigenheim$.$de and slap me again :)