将销售订单与采购申请单联查得出销售订单号，销售订单数量，产品编号，物料编号，物料数量。并将这五个写到另一张BOS自定义的单据中，请问实现思路，请给些代码提示。谢谢，以下是SQL

select FFCN1.F_FIVS_TEXT1 AS 销售订单号,FFCN1.FNUMBER AS 产品编号,FFCN1.F_FIVS_DECIMAL AS 生产数量,

TPR1.FBILLNO as 申请单号,MM1.FNUMBER 物料编号TPR2.FAPPROVEQTY as 批准数量,

TPR3.FREMAINQTY AS 剩余数量,

LEFT JOIN T_PUR_REQENTRY TPR2 ON TPR2.FID=TPR1.FID

LEFT JOIN T_PUR_REQENTRY_R TPR3 ON TPR3.FENTRYID=TPR2.FENTRYID

LEFT JOIN T_PUR_REQENTRY_L TPR4 ON TPR4.FENTRYID=TPR3.FENTRYID

LEFT JOIN (SELECT M1.FMATERIALID,M1.FNUMBER, M2.FNAME FROM T_BD_MATERIAL M1

LEFT JOIN T_BD_MATERIAL_L M2 ON M2.FMATERIALID=M1.FMATERIALID

WHERE M2.FLOCALEID=2052) MM1 ON MM1.FMATERIALID=TPR2.FMATERIALID

LEFT JOIN (SELECT FCN1.F_FIVS_TEXT1,M1.FNUMBER,M2.FNAME,FCN1.F_FIVS_DECIMAL,FCN1.F_FIVS_DATE FROM FivS_t_Cust_Entry100009 FCN1

LEFT JOIN T_BD_MATERIAL M1 ON M1.FMATERIALID=FCN1.F_FIVS_BASE

LEFT JOIN T_BD_MATERIAL_L M2 ON M2.FMATERIALID=M1.FMATERIALID

WHERE M2.FLOCALEID=2052 ) FFCN1 ON FFCN1.F_FIVS_TEXT1=TPR3.FDEMANDBILLNO

WHERE TPR1.FAPPLICATIONORGID=1 AND TPR4.FLOCALEID=2052 AND TPR1.FCANCELSTATUS<>'B' AND FFCN1.F_FIVS_TEXT1=TPR3.FDEMANDBILLNO

产品问题多表联查写入另一个单据体中,请帮帮我

产品问题 多表联查写入另一个单据体中,请帮帮我