从采购订单 获取自定义 备注 到 采购入库单

SELECT C.REM_PRD FROM TF_PSS_Z A,TF_PSS B,TF_POS_Z C,tf_pos d
WHERE
A.ITM =B.ITM AND A.PS_NO = B.PS_NO
and c.os_no=d.os_no and c.itm=d.itm
AND B.OS_NO =d.os_no and b.est_itm=d.pre_itm
and  b.ps_no=:ps_no
and b.itm=:itm

从采购订单更新数据到采购入库单 自定义 备注

update a
set a.rem_prd=c.rem_prd
FROM TF_PSS_Z A,TF_PSS B,TF_POS_Z C,tf_pos d
WHERE
A.ITM =B.ITM AND A.PS_NO = B.PS_NO
and c.os_no=d.os_no and c.itm=d.itm
AND B.OS_NO =d.os_no and b.est_itm=d.pre_itm

REM_PRD :自定义备注栏位