Subject | Re: [firebird-support] Subquery in "from" clause of Select statement |
---|---|
Author | Thomas Steinmaurer |
Post date | 2006-10-19T13:21:21Z |
> Can I use SQL command below with FB 1.5.3?Select
>
>
>
> Select t1.*, t2.*
>
> from table1 t1
>
> inner join (select * from table2) t2 on (t1.ID = t2.ID)
t1.*
, t2.*
from
table1 t1 inner join table2 t2 on (t1.ID = t2.ID)
Regards,
Thomas