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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
