jasajona wrote:

> Hello,
>
> if there is a query:
>
> select
> table1.field1,
> table1.field2
> from
> table1
> left join table2 on table1.field3 = table2.field1
>
> No fields from table table2 is being used. Will firebird execute left
> join table2?

It has to, because the join might cause each table1 row to be repeated
any number of times in the result set, depending on the number of
matching records in table2.

That's the point. If that's not what you want, why do you have the join
there in the first place?

What are you trying to do?

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64