Daniel,

The response below answer my question. Thanks.

Cicero

--- In firebird-support@yahoogroups.com, Daniel Rail <daniel@...> wrote:
>
> Hi,
>
> At October 19, 2006, 10:10 AM, Cicero 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)
>
>
> The statement itself can be written differently for FB 1.5.3. But, if
> you are asking in general if derived tables(the SQL standard name for
> subqueries in the FROM clause) are supported in FB 1.5.3, then the
> answer is NO. But, the support has been added in FB 2.0.
>
> Summary response:
> FB 1.5.x and prior versions: No, they are not supported.
> FB 2.0: Yes, they are supported.
>
> --
> Best regards,
> Daniel Rail
> Senior Software Developer
> ACCRA Consultants Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)
>