select
B.FNAME ,
A2.FBILLTYPEID,
A1.FMATERIALID ,
A2.FBILLNO,
C.FName AS 物料名称,
A2.FOWNEROUTID,
A2.FOWNERINID,
A3.FPRICE ,
A1.FQTY*A3.FPRICE AS FCOUNT, --成本价*调拨数量
A1.FQTY as FQTY1,
D.FTAXPRICE,
A1.FQTY *D.FTAXPRICE AS FCOUNT1, --含税单价*调拨数量
A1.FQTY *(D.FTAXPRICE -A1.FPRICE ) AS LR,
A2.FDATE
FROM
T_ORG_ORGANIZATIONS_l B
INNER JOIN T_STK_STKTRANSFEROUT A2 ON A2.FOWNEROUTID = B.FORGID
INNER JOIN T_STK_STKTRANSFEROUTENTRY A1 ON A1.FID=A2.FID
INNER JOIN T_STK_STKTRANSFERINENTRY_C A3 ON A3.FENTRYID = A1.FENTRYID
INNER JOIN T_BD_MATERIAL_L C ON C.FMATERIALID=A1.FMATERIALID
INNER JOIN T_IOS_PRICELISTENTRY D ON D.FMATERIALID=A1.FMATERIALID
INNER JOIN T_IOS_PRICELIST D2 ON D2.FID = D.FID
where A1.FMATERIALID = D.FMATERIALID
AND D2.FAUDITSTATUS = 'A'
AND A2.FDOCUMENTSTATUS = 'C'
AND A2.FTRANSFERBIZTYPE = 'OVERORGTRANSFER'
AND A2.FDATE >= '2016-09-01 00:00:00.000'
AND A2.FDATE <='2016-09-30 00:00:00.000'
AND D2.FEFFECTIVEDATE >= D.FEFFECTIVEDATE
AND D2.FEXPIRYDATE <= D.FEXPRIYDATE
AND A2.FBILLNO = 'FBDC000279'
GROUP BY A2.FDATE,B.FNAME,A1.FMATERIALID ,C.FName,A1.FQTY,A2.FOWNEROUTID,
A2.FOWNERINID,D.FMATERIALID,A2.FTRANSFERBIZTYPE,B.FORGID,A2.FDOCUMENTSTATUS ,
D2.FAUDITSTATUS,A1.FPRICE,FTAXPRICE,A1.FMATERIALID,A3.FPRICE,A2.FBILLTYPEID,A2.FBILLNO
代码意思，从7张表中取出一张表，表中含有需要的信息，一张企业的利润表。这是一张单据，单据编码‘FBDC000279’单据里面有8条信息，但是我查询出来了300条，大神们有没有思路，怎么修改？？？
