On 9/5/2012 4:54 PM, Petite Abeille wrote:
On Sep 5, 2012, at 10:38 PM, Igor Tandetnik <itandet...@mvps.org> wrote:
A select statement that would most closely resemble your update statement would
look like this:
select frequency, (select frequency from beta where beta.term = alpha.term)
from alpha;
This statement will always return exactly as many rows as there are rows in
alpha table.
And such statement should raise an exception if the scalar sub-query returns
multiple rows, no?
Definitely not in SQLite. I don't believe it would do that in other DBMS
either, but won't bet on it. SQLite would take the value from the first
row, or NULL if there are no rows.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
