Thank you, Philip, haven't thought to do filtering in ON place

--- In firebird-support@yahoogroups.com, "unordained"
<unordained_00@c...> wrote:

> That doesn't change anything with respect to the join semantics.
>
> select a."Nam", b."Pho" from TABLE1 a left join TABLE2 b on

b."Val"=:Val and b."Pos"=:Pos and

> a."ID"=b."ID_ref";
>
> If you try to use the WHERE clause, you'll exclude possible Table1

rows that you wanted to see,

> just because they joined to a Table2 row that you don't want.