Subject Re: [firebird-support] Subquery in "from" clause of Select statement
Author Martijn Tonies
> Can I use SQL command below with FB 1.5.3?
> Select t1.*, t2.*
> from table1 t1
> inner join (select * from table2) t2 on (t1.ID = t2.ID)

Have you tried?

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
My thoughts:
Database development questions? Check the forum!