update IV00101 set selnguom = baseuofm
--SELECT a.BASEUOFM, IV00101.SELNGUOM
FROM IV00101 INNER JOIN
(SELECT IV00101_1.ITEMNMBR, IV00101_1.ITEMDESC, IV40201_1.BASEUOFM, IV00101_1.DECPLQTY
FROM IV00101 AS IV00101_1 INNER JOIN
IV40201 AS IV40201_1 ON IV00101_1.UOMSCHDL = IV40201_1.UOMSCHDL) AS a ON IV00101.ITEMNMBR = a.ITEMNMBR
WHERE (IV00101.SELNGUOM = '')
No comments:
Post a Comment