Igor, Thank you for your consideration and reply.
On 2/5/2011 11:12 AM, Igor Tandetnik wrote: > Jeff Hennick<sqli...@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 > produce multiple rows. This may be my problem. I "knew" it, but was thinking "one column", not "one row." I'm going to have to do some more thinking on this. My first approach, before a sub-Select, had been a self-Join. Maybe I'll have to create a temporary table and Join it. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
