On 12/8/2014 3:35 PM, Luuk wrote:
update temp_table set id=(select id from some_table where c=42), operation='UPDATE' where exists (select 1 from some_table s, temp_table t where s.a=t.a and s.b=t.b and s.c=42);
Same thing. Your WHERE clause doesn't depend on the values in the current row of temp_table - it's either always true, or always false.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users