主题：合并单元格

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

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

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

请看懂下面的分组代码：

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