Subject Re: [firebird-support] Subquery in "from" clause of Select statement
Author Daniel Rail

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. (
ACCRA Med Software Inc. (