Hi,

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
documents:

<derived table> ::= <table subquery>

<table subquery> ::= <subquery>

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)