Subject Re: [firebird-support] SubQuery / SubSelect / Nested Query Support
Author Daniel Rail

At September 26, 2003, 18:54, Leyne, Sean wrote:

>> > What is it called when you do a select from a select statement. ie.
>> > Select * from (Select * from table). Is called subquery or
>> something
>> > else. Just so I can refer to it in the future.
>> Subquery.

> Interesting, Arno Brinkman (the developer who added support for them for
> v2.0) called them "derived" tables.

It's the same thing. Here's what can be found in the standards

<derived table> ::= <table subquery>

<table subquery> ::= <subquery>

Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (