select a.编码,a.单位名称,应缴金额总和=sum(isnull(c.应缴金额,0)) from a表 as a,b表 as b,c表 as c where a.内码=b.内码 and b.识别号=c.识别号 group by a.编码,a.单位名称
select a.编码,a.单位名称,sum(c.应缴金额) as 应缴金额总和 from 表c c left join 表b b on c.识别号=b.识别号 left join 表a a on b.内码=a.内码 where datepart(yy,c.处理日期)=2004 group by a.编码,a.单位名称 order by a.编码,a.单位名称
select a.编码,a.单位名称,sum(c.应缴金额) as 应缴金额总和 from 表c c left join 表b b on c.识别号=b.识别号 left join 表a a on b.内码=a.内码 where datepart(yy,c.处理日期)=2004 group by a.编码,a.单位名称 order by a.编码,a.单位名称
select a.编码 ,a.单位名称,sum(c.应教金额) AS TOTAL from a inner join b on a.内码=b.内码 inner join c on b.识别号=c.识别号 and substr(cast(c.处理日期,char(30)),1,4)='2004' group by a.编码 ,a.单位名称 (函数语法是DB2的)
select a.编码 ,a.单位名称,sum(c.应教金额) AS TOTAL from a inner join b on a.内码=b.内码 inner join c on b.识别号=c.识别号 and substr(cast(c.处理日期 AS char(30)),1,4)='2004' group by a.编码 ,a.单位名称
left join 表b b
on c.识别号=b.识别号
left join 表a a
on b.内码=a.内码
where datepart(yy,c.处理日期)=2004
group by a.编码,a.单位名称
order by a.编码,a.单位名称
left join 表b b
on c.识别号=b.识别号
left join 表a a
on b.内码=a.内码
where datepart(yy,c.处理日期)=2004
group by a.编码,a.单位名称
order by a.编码,a.单位名称
from a inner join b on a.内码=b.内码 inner join c on b.识别号=c.识别号 and substr(cast(c.处理日期,char(30)),1,4)='2004'
group by a.编码 ,a.单位名称 (函数语法是DB2的)
from a inner join b on a.内码=b.内码 inner join c on b.识别号=c.识别号 and substr(cast(c.处理日期 AS char(30)),1,4)='2004'
group by a.编码 ,a.单位名称