]]>re: SQL緇忓吀闈㈣瘯棰樺強(qiáng)絳旀http://www.aygfsteel.com/spinage/archive/2009/11/27/299911.html#303958HarryGodHarryGodFri, 27 Nov 2009 10:26:00 GMThttp://www.aygfsteel.com/spinage/archive/2009/11/27/299911.html#303958sum(case when b.mon=1 then b.yj else 0 end) as '涓鏈堜喚', sum(case when b.mon=2 then b.yj else 0 end) as '浜屾湀浠?, sum(case when b.mon=3 then b.yj else 0 end) as '涓夋湀浠?, sum(case when b.mon=4 then b.yj else 0 end) as '鍥涙湀浠?, sum(case when b.mon=5 then b.yj else 0 end) as '浜旀湀浠?, sum(case when b.mon=6 then b.yj else 0 end) as '鍏湀浠?, sum(case when b.mon=7 then b.yj else 0 end) as '涓冩湀浠?, sum(case when b.mon=8 then b.yj else 0 end) as '鍏湀浠?, sum(case when b.mon=9 then b.yj else 0 end) as '涔?jié)鏈堜?, sum(case when b.mon=10 then b.yj else 0 end) as '鍗佹湀浠?, sum(case when b.mon=11 then b.yj else 0 end) as '鍗佷竴鏈堜喚', sum(case when b.mon=12 then b.yj else 0 end) as '鍗佷簩鏈堜喚' from table2 a left join table1 b on a.dep=b.dep group by a.dep;