--查詢各表單內容
SELECT b.FORM_NO,b.FORM_ID,c.ITEM_SEQ,c.ITEM_NO,c.ITEM_NAME,a.*
FROM OAS.FORM_ITEM a,OAS.FORM_INFO b,OAS.TYPE_ITEM c
WHERE a.FORM_ID=b.FORM_ID AND a.ITEM_SEQ=c.ITEM_SEQ
AND b.FORM_NO IN('KM09G032') AND c.ITEM_SEQ IN(3041,3027)
--更新表單內容之PO價格
UPDATE OAS.FORM_ITEM SET ITEM_VALUE=26354
FROM OAS.FORM_ITEM a,OAS.FORM_INFO b,OAS.TYPE_ITEM c
WHERE a.FORM_ID=b.FORM_ID AND a.ITEM_SEQ=c.ITEM_SEQ
AND b.FORM_NO IN('KM09G032') AND c.ITEM_SEQ IN(3027)
--更新表單內容之PO幣別
UPDATE OAS.FORM_ITEM SET ITEM_VALUE='USD'
FROM OAS.FORM_ITEM a,OAS.FORM_INFO b,OAS.TYPE_ITEM c
WHERE a.FORM_ID=b.FORM_ID AND a.ITEM_SEQ=c.ITEM_SEQ
AND b.FORM_NO IN('KM09G032') AND c.ITEM_SEQ IN(3041)