采购流程单据表查询SQL

SELECT po.FBILLTYPEID, po.FID '采购订单内码' ,po.FBILLNO '采购订单编码',po.FDATE , po1.FMATERIALID '明细物料内码' ,mat.FNUMBER '物料编码' ,mat_l.FNAME '物料名称' ,
       aux.FF100001 '保税类型内码' , tFF100001.FNUMBER '保税类型编码' , tFF100001_l.FDATAVALUE '保税类型名称',po1.FQTY,po1.FENTRYID
FROM   T_PUR_POORDER po
       LEFT JOIN T_PUR_POORDERENTRY po1 ON ( po.FID = po1.FID )
       LEFT JOIN T_BD_MATERIAL mat ON ( po1.FMATERIALID = mat.FMATERIALID )
       LEFT JOIN T_BD_MATERIAL_L mat_l ON (   mat.FMATERIALID = mat_l.FMATERIALID
                                              AND mat_l.FLOCALEID = 2052
                                          )
       LEFT JOIN T_BD_FLEXSITEMDETAILV aux ON po1.FAUXPROPID = aux.FID
       LEFT JOIN T_BAS_ASSISTANTDATAENTRY tFF100001 ON aux.FF100001 = tFF100001.FENTRYID
       LEFT JOIN T_BAS_ASSISTANTDATAENTRY_L tFF100001_l ON (   tFF100001.FENTRYID = tFF100001_l.FENTRYID
                                                               AND tFF100001_l.FLOCALEID = 2052
                                                           )
WHERE po.FBILLNO='CGDD000006'

SELECT a.FBILLTYPEID, a.FID,a.FBILLNO,a.FDATE,b.FMATERIALID,mat.FNUMBER '物料编码' , mat_l.FNAME '物料名称' , aux.FF100001 '保税类型内码' ,
       tFF100001.FNUMBER '保税类型编码' , tFF100001_l.FDATAVALUE '保税类型名称',b.FLOT,b.FLOT_TEXT,b.FSTOCKID,b.FSTOCKLOCID,
    b.FActReceiveQty '交货数量' ,c.FREJECTQTY '拒收数量',c.FCHECKQTY '检验数量',c.FCHECKJOINQTY '检验关联数量',c.FRETURNQTY'退料数量',c.FRETURNJOINQTY'退料关联数量',
    c.FINSTOCKQTY'入库数量',c.FINSTOCKJOINQTY'合格入库关联数量',c.FCSNRECEIVEQTY'让步接收数量',c.FCSNRECEIVEJOINQTY'让步接收关联数量',
    c.FREFUSEQTY'判退数量',c.FREFUSEJOINQTY'不合格关联数量',c.FRECEIVEQTY'合格数量',
    b.FORDERBILLNO,b.FPOORDERENTRYID,b.FSRCID,b.FSRCFORMID,b.FSRCBILLNO,b.FSRCENTRYID,b.FENTRYID
FROM dbo.T_PUR_RECEIVE a
INNER JOIN dbo.T_PUR_RECEIVEENTRY b ON b.FID=a.FID
LEFT JOIN dbo.T_PUR_RECEIVEENTRY_S c ON c.FID=b.FID AND c.FENTRYID=b.FENTRYID
 LEFT JOIN T_BD_MATERIAL mat ON ( b.FMATERIALID = mat.FMATERIALID )
       LEFT JOIN T_BD_MATERIAL_L mat_l ON (   mat.FMATERIALID = mat_l.FMATERIALID
                                              AND mat_l.FLOCALEID = 2052
                                          )
       LEFT JOIN T_BD_FLEXSITEMDETAILV aux ON b.FAUXPROPID = aux.FID
       LEFT JOIN T_BAS_ASSISTANTDATAENTRY tFF100001 ON aux.FF100001 = tFF100001.FENTRYID
       LEFT JOIN T_BAS_AS