Thomas,

the SQL below was writte n justo to clarify my question. I know the
correct form of to do this. My question is: Subquery is supported in
"from" clause of "select" in FB 1.5.3?

Thanks

Cicero


--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...>
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)
>
>
> Select
> t1.*
> , t2.*
> from
> table1 t1 inner join table2 t2 on (t1.ID = t2.ID)
>
>
> Regards,
> Thomas
>