select a.cardtype ,sum(a.kcNum),sum(b.rknum),sum(c.chkNum) from kc a,chk b,rk c where a.cardtype =+ b.cardtype and a.cardtype =+ c.cardtype group by kc.cardtype
试试: select t1.cardtype,kcNum=isnull(sum(t1.kcNum),0),rkNum=isnull(sum(t2.rkNum),0),chkNum=isnull(sum(t3.chkNum),0) from kc t1 left join rk t2 on t1.cardtype=t2.cardtype left join chk t3 on t1.cardtype=t3.cardtype group by t1.cardtype order by t1.cardtype
select t1.cardtype,kcNum=isnull(sum(t1.kcNum),0),rkNum=isnull(sum(t2.rkNum),0),chkNum=isnull(sum(t3.chkNum),0)
from kc t1 left join rk t2 on t1.cardtype=t2.cardtype
left join chk t3 on t1.cardtype=t3.cardtype
group by t1.cardtype
order by t1.cardtype
我现在还没工作,但马上就要工作了!!!
[email protected]
我是拨号呀,下载会死的!还好找到了mssql7的盘~