SELECT LEFT(ST.BOM_NO,10) AS BOM_NO,ST.NAME,ST.PRD_NO, ST.PRD_MARK, NULL AS CUS_NO,ST.UNIT,SUM(ST.QTY*PT.QTY) AS QTY FROM TF_POS PT LEFT JOIN TF_BOM_SO ST ON ST.BOM_NO=PT.ID_NO
GROUP BY LEFT(ST.BOM_NO,10),ST.NAME,ST.PRD_NO,ST.PRD_MARK,ST.UNIT
GROUP BY LEFT(ST.BOM_NO,10),ST.NAME,ST.PRD_NO,ST.PRD_MARK,ST.UNIT
GROUP BY LEFT(ST.BOM_NO,10),ST.NAME,ST.PRD_NO,ST.PRD_MARK,ST.UNIT