| Subject | Re: [firebird-support] Subquery in "from" clause of Select statement |
|---|---|
| Author | Daniel Rail |
| Post date | 2006-10-19T16:52:50Z |
Hi,
At October 19, 2006, 10:10 AM, Cicero wrote:
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)
At October 19, 2006, 10:10 AM, Cicero wrote:
> Hi!The statement itself can be written differently for FB 1.5.3. But, if
> 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)
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)