Çósql²éѯÓï¾ä£¨oracle£© - .NET¼¼Êõ / ASP.NET

A񡜧
 ÈÕÆÚ ×Éѯ´ÎÊý
 2010-2-1 2
 2010-2-2 3
 2010-2-8 7
 
 
 B±í£º
 ÈÕÆÚ Í¶Ëß´ÎÊý
 2010-2-1 2
 2010-2-2 3
 2010-2-3 6
 
 C±í£º
 ÈÕÆÚ ·´À¡´ÎÊý
 2010-2-1 2
 2010-2-2 2 
 2010-2-4 4
 2010-2-8 1
 
 
½á¹û£º
ÈÕÆÚ ×Éѯ´ÎÊý ͶËß´ÎÊý ·´À¡´ÎÊý
2010-2-1 2 2 2
2010-2-2 3 3 2
2010-2-3 0 6 0
2010-2-4 0 0 4
2010-2-8 7 0 1

---

¸ßÊÖ¶¼µ½ÄÄÈ¥ÁË

---

SQL code:

select a.date,sum(×Éѯ´ÎÊý) as ×Éѯ´ÎÊý, sum(ͶËß´ÎÊý) as ͶËß´ÎÊý, sum(·´À¡´ÎÊý) as ·´À¡´ÎÊý
from a
join b on a.date=b.date
join c on a.date=c.date
group by a.date

---

ÒýÓÃ

SQL code

select a.date,sum(×Éѯ´ÎÊý) as ×Éѯ´ÎÊý, sum(ͶËß´ÎÊý) as ͶËß´ÎÊý, sum(·´À¡´ÎÊý) as ·´À¡´ÎÊý
from a
join b on a.date=b.date
join c on a.date=c.date
group by a.date

¿´ÌṩµÄÊý¾Ý£¬