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? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
