这是SERVER SQL中的update 语句
UPDATA A
SET A.SDVR03 = B.ABTICKER
FROM PRODDTA.F4211 A,PRODDTA.F0101 B
WHERE A.SDSHAN = B.ABAN8 and A.SDVR03 in null在PL/SQL 中这个update 语句应该曾样写 !!谢谢了!!
UPDATA A
SET A.SDVR03 = B.ABTICKER
FROM PRODDTA.F4211 A,PRODDTA.F0101 B
WHERE A.SDSHAN = B.ABAN8 and A.SDVR03 in null在PL/SQL 中这个update 语句应该曾样写 !!谢谢了!!
updata->updatein null->is null我是不是太拘小节了?-_-!
那个a表到底是别名还是主表名 很不清楚 暂且当两张表来处理了
MERGE INTO PRODDTA.F4211 A
USING PRODDTA.F0101 B
ON (A.SDSHAN = B.ABAN8 and A.SDVR03 IS null)
WHEN MATCHED THEN
UPDATE SET A.SDVR03 = B.ABTICKER;