Igor Tandetnik was right on this. Thank you.
Scalar Subqueries
A SELECT statement enclosed in parentheses may appear as a scalar
quantity. A SELECT used as a scalar quantity must return a result set
with a single column. The result of the expression is the value of the
only column in
Igor,
Thank you for your consideration and reply.
On 2/5/2011 11:12 AM, Igor Tandetnik wrote:
Jeff Hennicksqli...@jeff-h.com wrote:
When syntactically used as an expression (e.g. in SELECT clause), a subselect
produces a single value. When used as a table (e.g. in FROM clause), it may
I am having problems with Sub-Select apparently working on one row
rather than the whole table.
registrations table:
Class | Term | (Other student columns)
CC123 | 101 | ...
CC002 | 101
CC050 | 111
CC123 | 101
CC123 | 102
...
Desired ultimate output counts by class and term, with totals and
Jeff Hennick sqli...@jeff-h.com wrote:
I am having problems with Sub-Select apparently working on one row
rather than the whole table.
When syntactically used as an expression (e.g. in SELECT clause), a subselect
produces a single value. When used as a table (e.g. in FROM clause), it may