select a.[date] ,a.表1money ,b.表2money ,c.表3money from (select YEAR([date]) As [date],sum(money) 表1money from 表1 group by YEAR([date])) a, (select YEAR([date]) As [date],sum(money) 表2money from 表2 group by YEAR([date])) b, (select YEAR([date]) As [date],sum(money) 表3money from 表3 group by YEAR([date])) c where a.[date]=b.[date]=c.[date]
select a.[date] ,a.表1money ,b.表2money ,c.表3money from
(select YEAR([date]) As [date],sum(money) 表1money from 表1 group by YEAR([date])) a,
(select YEAR([date]) As [date],sum(money) 表2money from 表2 group by YEAR([date])) b,
(select YEAR([date]) As [date],sum(money) 表3money from 表3 group by YEAR([date])) c
where a.[date]=b.[date]=c.[date]