摘要： 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 阅读全文