Balanyi,

B> WHERE
B> T2.TYPE = :WANTEDTYPE

OTTOMH: I think this is excluding from the result set all the rows
where T2.TYPE is null, effectively turning the outer join into the
equivalent of an inner join. Try to add "or T2.TYPE is null" and see
what happens.
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================