kurgbe wrote:

>
> "Subqueies are defined as queries that produce data that is not the
> final output of the statement, but will further processed within
> statement.

That's not quite true. Scalar subqueries in the select list do
produce data that is part of the final output of the statement.
Unpleasant as it may be, the standard itself is the only real
authority on what the SQL Standards committees consider standard
SQL.

Regards,


Ann