USE T23S001 UPDATE T22S001.DBO.GENERAL_PURCHASE SET SUPPCODE='21LA019' WHERE SUPPCODE='22LS008' UPDATE T22S001.DBO.SEND_TO_JOB SET JOBCODE='21LA001' WHERE JOBCODE='22LM007' --SERIAL NO 9 IN GENERAL PURCHASE --sERIAL NO 114 IN SEND TO JOB
USE T23S001 UPDATE T22S001.DBO.GENERAL_PURCHASE SET SUPPCODE='21LA019' WHERE SUPPCODE='22LS008' UPDATE T22S001.DBO.SEND_TO_JOB SET JOBCODE='21LA001' WHERE JOBCODE='22LM007' --SERIAL NO 9 IN GENERAL PURCHASE --sERIAL NO 114 IN SEND TO JOB