MERGE INTO BB B USING (SELECT * FROM AA) A ON(A.ID = B.ID) WHEN MATCHED THEN UPDATE SET B.BLUE_BALL1 = A.BLUE_BALL1 WHERE A.ID = B.ID WHEN NOT MATCHED THEN INSERT VALUES(A.ID,A.BLUE_BALL1);
MERGE INTO BB B USING (SELECT * FROM AA) A ON(A.ID = B.ID) WHEN MATCHED THEN UPDATE SET B.BLUE_BALL1 = A.BLUE_BALL1 WHERE A.ID = B.ID WHEN NOT MATCHED THEN INSERT VALUES(A.ID,A.BLUE_BALL1);