mysql的两表联合更新和postgresql的两表联合更新的区别

mysql两表更新中可以使用join语句，pg两表更新中只能用语法update set from语法。 

mysql两表更新

update dzys_User_CallList_Self a, dzys_user b
 set a.Opp_CustID=b.CUST_ID
where a.OPP_NUMBER=b.USER_NUMBER；

postgresql两表更新

UPDATE dzys_User_CallList_Self as a    
set  Opp_CustID=b.CUST_ID
from dzys_user as b     
where a.OPP_NUMBER=b.USER_NUMBER;