sql¸´ÔÓµÄÐÐÁÐת»»

SQLÓï¾ä£ºselect ºÏ¼Æ±í.ÓªÏúÖÐÐÄ,cust_type.cust_type_,sum(Ã÷ϸ±í.charge) as ºÏ¼Æ from ºÏ¼Æ±í,cust_type,Ã÷ϸ±í 
where ºÏ¼Æ±í.·þÎñʵÀýºÅÂë=cust_type.acc_nbr and ºÏ¼Æ±í.·þÎñʵÀýºÅÂë=Ã÷ϸ±í.acc_nbr and Ã÷ϸ±í.acc_nbr=cust_type.acc_nbr
group by ºÏ¼Æ±í.ÓªÏúÖÐÐÄ,cust_type.cust_type_ order by ºÏ¼Æ±í.ÓªÏúÖÐÐÄ,cust_type.cust_type_µÄЧ¹ûÊÇÕâÑùµÄ

ÎÒÏëת³É
¾ÍÊÇÈÃËùÓеķֹ«Ë¾×ªµ½ÐÐÉÏÈ¥ ÖмäÏÔʾµÄ¶¼ÊÇÓªÏúÖÐÐĺÍÒµÎñÀàÐ͵ķÑÓÃ

---

ÎÞͼÎÞÕæÏà

---

ÒýÓÃ

ÎÞͼÎÞÕæÏà

.

---

ÒýÓÃ

ÎÞͼÎÞÕæÏà

..

---

±§Ç¸°¡ ÎÒ¸øÄãÃÇ»­Ò»Ï°É
Ô­À´µÄ½á¹¹  
ÓªÏúÖÐÐÄ ·ÑÓÃÀàÐÍ ºÏ¼Æ
¹«Ë¾1 ¹Ì»° 100
¹«Ë¾1 ÎÞÏß 200
¹«Ë¾1 ADSL 1000
¹«Ë¾2 ¹Ì»° 0
¹«Ë¾2 ÎÞÏß 500
¹«Ë¾2 ADSL 1000
¹«Ë¾3 ÎÞÏß 300

ÐèÒª¸Ä³ÉÕâÖÖ¸ñʽµÄ
·ÑÓÃÀàÐÍ ¹«Ë¾1 ¹«Ë¾2 ¹«Ë¾3
¹Ì»° 100 0  
ÎÞÏß 200 500 300
ADSL 1000 1000  

¾ÍÊÇsqlµÄÐÐÁÐת»» µ«ÊÇÎÒת²»³É °ÝÍаïæÁË°¡ лл~~~

---

SQL code:
select ·ÑÓÃÀàÐÍ,
sum(case when ÓªÏúÖÐÐÄ='¹«Ë¾1' then ºÏ¼Æ else 0 end) ¹«Ë¾1,
sum(case when ÓªÏúÖÐÐÄ='¹«Ë¾2' then ºÏ¼Æ else 0 end) ¹«Ë¾2,
sum(case when ÓªÏúÖÐÐÄ='¹«Ë