UPDATE       POP10100
SET                REQTNDT = XW_ReqHdr.ReqDate
FROM            POP10110 INNER JOIN
                         POP10100 ON POP10110.PONUMBER = POP10100.PONUMBER LEFT OUTER JOIN
                         XW_ReqHdr ON POP10110.Source_Document_Number = XW_ReqHdr.ReqNbr
WHERE        XW_ReqHdr.ReqDate > '1900-01-01'
 
No comments:
Post a Comment