Martijn,

Yes, I tried this and don't work as expected.
Then I'm asking here. There is another aproach to do this in FB 1.5.3?
I know FB 2.0 support this sintaxe.

Thanks


Cicero


--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:

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