主题：[求助]查询、统计问题？

  你这种不能用连接查询啊，你这种是要把两个表的数据先合并，在统计啊。你就不能上传一个例子啊

 比如这样

Select 权利人,sum(补偿金额) As [装修补偿],sum(面积) As [面积],sum(评估价格) As [房屋补偿] From {权利人名单} as a

 inner join (select xxx, xxx, xxx from {装修明细} union select yyyy, yyyy, yyyy from {农房}) as b

 on a.xxx = b.xxx and a.yyy = b.yyy