>>>>> "Jack" == Jack Gao <wei(at)gaofamily(dot)org> writes:
Jack> So, I can't use JOIN in UPDATE?
You are trying to update two different tables. Use a transaction
instead.
begin transaction;
update foo ....;
update bar ....;
end transaction;
roland
--
PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD RL Enterprises
roland(at)rlenter(dot)com 76-15 113th Street, Apt 3B
roland(at)astrofoto(dot)org Forest Hills, NY 11375