MERGE INTO EMPLOYE AS EM
USING MANAGER AS MA
ON EM.EMPLOYEID=MA.EMPLOYEID
WHEN MATCHED THEN UPDATE SET EM.SALARY=MA.SALARY
WHEN NOT MATCHED THEN INSERT VALUES (MA.EMPLOYEID,MA.NAME,MA.SALARY)
MERGE INTO EMPLOYE AS EM
USING MANAGER AS MA
ON EM.EMPLOYEID=MA.EMPLOYEID
WHEN MATCHED THEN UPDATE SET EM.SALARY=MA.SALARY
WHEN NOT MATCHED THEN INSERT VALUES (MA.EMPLOYEID,MA.NAME,MA.SALARY)
本文标题:2018-01-14
本文链接:https://www.haomeiwen.com/subject/wtekoxtx.html
网友评论