用户zM8pH9695594(提问者)SELECT
A.FLOT,
A.FLOT_TEXT,
A.FBILLNO,
A.FNUMBER,
A.FOLDNUMBER,
A.FID,
A.FENTRYID,
A.FMATERIALID,
A.FREALQTY,
AVG(A.FPRICE) [FPRICE]
FROM (
SELECT DISTINCT TSI.FLOT,
TSI.FLOT_TEXT,
TS.FBILLNO,
TBM.FNUMBER,
TBM.FOLDNUMBER,
TSI.FID,
TSI.FENTRYID,
TSI.FMATERIALID,
TSI.FREALQTY,
TF.FPRICE
FROM T_STK_INSTOCKENTRY TSI
LEFT JOIN T_STK_INSTOCK TS ON TSI.FID=TS.FID
LEFT JOIN T_BD_MATERIAL TBM ON TSI.FMATERIALID=TBM.FMATERIALID
LEFT JOIN T_STK_INSTOCKENTRY_F TF ON TSI.FENTRYID=TF.FENTRYID
WHERE EXISTS (SELECT TAO.FLOT FROM T_AR_RECEIVABLEENTRY_O TAO WHERE TAO.FLOT=TSI.FLOT)AND TSI.FLOT!=\'\'
) A
where A.FLOT_TEXT=\'0058202104230019\'
GROUP BY A.FLOT,
A.FLOT_TEXT,
A.FBILLNO,
A.FNUMBER,
A.FOLDNUMBER,
A.FID,
A.FENTRYID,
A.FMATERIALID,
A.FREALQTY
这样显示还是两条数据