Hi,

> SELECT
> DISTINCT
> TAB_Tooleping.UID
> FROM
> TAB_Tooleping
> JOIN TAB_Tootaja ON (TAB_Tootaja.UID = TAB_Tooleping.Tooline)
> LEFT JOIN TAB_Graafik ON (TAB_Graafik.Tooleping = TAB_Tooleping.UID)
> LEFT JOIN TAB_Vahetus ON (TAB_Vahetus.UID = TAB_Graafik.Vahetus)
> WHERE
> ((TAB_Tooleping.Alates <= '31.10.2006') AND
> ((TAB_Tooleping.Kuni IS NULL) OR (TAB_Tooleping.Kuni >= '01.10.2006'))) AND
> (((TAB_Graafik.Kuupaev <= '31.10.2006') AND (TAB_Graafik.Kuupaev >= '01.10.2006')) OR
> (TAB_Graafik.Kuupaev IS NULL)) AND
> ((TAB_Vahetus.Kestus > 480) OR (TAB_Tootaja.Isikukood STARTING '3') OR (TAB_Tooleping.Tooline =
> 1))
> ORDER BY
> TAB_Tootaja.Perenimi ASC

Note also in this query (TAB_Vahetus.Kestus > 480), because this is on a LEFT JOIN part !!
This could be the intention, but it's a little bit confusing.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
General database development support:
http://www.databasedevelopmentforum.com

Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Firebird and Interbase users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info

--------------------------------------------------------------------------------
Mijn Postvak In wordt beschermd door SPAMfighter
780 spam-mails zijn er tot op heden geblokkeerd.
Download de gratis SPAMfighter vandaag nog!