Re: [sqlite] Sub-Select reports only row one value?

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

Re: [sqlite] Sub-Select reports only row one value?

Igor, Thank you for your consideration and reply. On 2/5/2011 11:12 AM, Igor Tandetnik wrote: > Jeff Hennick 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