postgresql和mysql两表更新的不同语法

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;

memsql两表更新
update ICLVCST_LBL_CST_FST a , CST_WHT_TBL2 b on b.CST_ID = a.Cst_ID set a.Alrdy_VrfCall_Ind = '9' where CC_Avy_ID_Dsc='1' ;