UPDATE CUSTOMERS A -- 使用别名 SET (CITY_NAME, CUSTOMER_TYPE) = (SELECT B.CITY_NAME, B.CUSTOMER_TYPE FROM TMP_CUST_CITY B WHERE B.CUSTOMER_ID = A.CUSTOMER_ID) WHERE EXISTS (SELECT 1 FROM TMP_CUST_CITY B WHERE B.CUSTOMER_ID = A.CUSTOMER_ID); update F_USERINFO A set( english_name,reg_cell_phone)=( SELECT b.name, B.tel FROM F_USERINFO_1028 B WHERE B.Login_Name = A.Login_Name )WHERE EXISTS (SELECT 1 FROM F_USERINFO_1028 B WHERE B.Login_Name = A.Login_Name);
标签:CUSTOMER,Name,oracel,excel,sql,Login,WHERE,ID,SELECT From: https://www.cnblogs.com/qxqbk/p/16843175.html