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