On 9/5/2012 4:35 PM, Igor Tandetnik wrote:
On 9/5/2012 4:32 PM, E. Timothy Uy wrote:
Igor, what happens if there are multiple hits for
SELECT frequency FROM beta WHERE beta.term
= alpha.term
There can't be multiple hits, or even a single hit. This statement will
not run, as it's not syntactically valid.
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.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users