"Dusan Gibarac" <[email protected]> wrote in message news:[email protected] > There are tables t1( f11, f12) and table t2(f21, f22) and one > has to update field t1.f12 with values t2.f22 where t1.f11 = t2.f21.
update t1 set f12 = (select f22 from t2 where f11 = f21); Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
