| Subject | Re: [firebird-support] Subquery in "from" clause of Select statement |
|---|---|
| Author | Helen Borrie |
| Post date | 2006-10-19T13:32:40Z |
At 11:10 PM 19/10/2006, you wrote:
table2) in your output specification.
Select t1.*, t2.*
from table1 t1
join table 2 t2 on t1.ID = t2.ID
./hb
>Hi!No. What are you trying to do? You already have (select * from
>
>
>
>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)
table2) in your output specification.
Select t1.*, t2.*
from table1 t1
join table 2 t2 on t1.ID = t2.ID
./hb