Indeed. A "derived" tables is what solkrin is talking about. Maybe internally a subquery
and a derived table are treated similary, but from SQL's semantic point of view they are
two different thing.

A derived table is, if you have imagination, an unnamed view. A derived table helps to
establish the universe of rows from where the result should be found.

Joins, where clauses and subqueries draw the imaginary boundary of what records of
the universe are in the result.

Regards,
Daniel Berstein.

On 26 Sep 2003 at 17: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.
>
>
> Sean
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>