>>>>> "Jack" == Jack Gao <wei@gaofamily.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@rlenter.com 76-15 113th Street, Apt 3B
roland@astrofoto.org Forest Hills, NY 11375