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
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com