S e le ct xm1 as 项目分类,rq as 记帐日期,dw1 as 摘要,zy as 内容,je1 as 工程开票_金额,je2 as 工程开票_销项税,je3 as 工程开票_价税合计,fk1 as 工程开票_收回工程款,je4 as 成本发票支出_金额,je5 as 成本发票支出_进项税,je6 as 成本发票支出_价税合计,fk2 as 成本发票支出_已支付款,_Identify  FROM {pzk} WHERE 标志=\'成本付款\' or 标志=\'工程发票\' or 标志=\'工程收款\'or 标志=\'材料发票\'or 标志=\'劳务发票\'or 标志=\'报销发票\'  ORDER BY xm1,rq

上面生成的查询表，如何在select语句中加代码，把xm1相同的合并一个单元格？

1、你要合并模式？

http://www.foxtable.com/webhelp/scr/0157.htm

2、你要合并那些数据？合并起来要怎么显示？截图或实例说明。

S e l e ct xm1 as 项目分类,年月,rq as 记帐日期,dw1 as 摘要,zy as 内容,je1 as 工程开票_金额,je2 as 工程开票_销项税,je3 as 工程开票_价税合计,fk1 as 工程开票_收回工程款,je4 as 成本发票支出_金额,je5 as 成本发票支出_进项税,je6 as 成本发票支出_价税合计,fk2 as 成本发票支出_已支付款,ye1 as 余额_工程发票减已收工程款,ye2 as 余额_已收工程款减支付材料票,ye3 as 余额_销项税减进项税,_Identify  FROM {pzk} WHERE 标志=\'成本付款\' or 标志=\'工程发票\' or 标志=\'工程收款\'or 标志=\'材料发票\'or 标志=\'劳务发票\'or 标志=\'报销发票\' GROUP BY xm1  ORDER BY xm1,rq

加上GROUP BY xm1，按项目分类分组，为什么语法错误 

你根据什么分组？你是不是要根据xm1、年月、rq、dw1 等一起分组？你需要汇总的数据是哪些？

请看懂下面的分组代码：

Select 编号, 日期, sum(数量) as 总数量, sum(金额) as 总金额, max(摘要) as 摘要 from {表A} group by 编号,日期