Hi,

> 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?

Of course.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com