John McMahon wrote: > should be > UPDATE CUSTOMERS -- remove 'as c' > SET > cust1 = (select customer from test where custnum = CUSTOMERS.custnum), > WHERE custnum IN (SELECT custnum FROM test)
Yes. Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
