Thursday, July 15, 2004, 10:06:04 AM, Wolfgang Breitling (breitliw@xxxxxxxxxxxxx) wrote: >> 1. The subquery defines a *new* table of rows. WB> No, it does not. Ok. I've started to do a bit of digging in the 1999 ANSI SQL standard. Section 7.5 describes the FROM clause as containing a <table reference list>: FROM <table reference list> <table reference list> ::= <table reference> ... Later, section 7.6 defines <table reference> as follows: <table reference> ::= <table primary> | <joined table> <table primary> can be many things, one of which is a <derived table>, and a <derived table>, in turn, is defined as a <table subquery>. The standard does seem here, to put a subquery in the FROM clause on an equal footing with a table that you specify by name. A subquery is simply another way of specifying a table. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:jonathan@xxxxxxxxxxx Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://five.pairlist.net/mailman/listinfo/oracle-article, or send email to Oracle-article-request@xxxxxxxxxxx and include the word "subscribe" in either the subject or body. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------