Hi,

> No fields from table table2 is being used. Will firebird execute left
>join table2?

yes, it will. at least on FB 1.5 (try yourself and see it)


Regards,
Anderson Farias