Helen,

I know this SQL isn't a good example, but my question is:

Does FB 1.5.3 support Subquery in "from" clause of "Select"?

Thanks

Cicero

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 11:10 PM 19/10/2006, you wrote:
>
> >Hi!
> >
> >
> >
> >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)
>
> No. What are you trying to do? You already have (select * from
> table2) in your output specification.
>
> Select t1.*, t2.*
> from table1 t1
> join table 2 t2 on t1.ID = t2.ID
>
> ./hb
>