TERADATE JOIN UPDATA
update T05_Evt_Pay a set partyid = T05_ARREAR_AGMT.partyidwhere a.OWEAgmtNum = T05_ARREAR_AGMT.OWEAgmtNumand T05_ARREAR_AGMT.partyid <> ''and T05_ARREAR_AGMT.partyid = ''set后面不能用别名,其他出现ambiguous的用[@more@]
帮高扬妹子测试
test.............................[@more@]