ÇóSQLÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

Èë²Ö±í£º
ÈÕÆÚ »õÆ· ÊýÁ¿
2009-12-01 aa 20
2009-12-03 aa 20
2009-12-04 bb 20

³ö²Ö±í£º
ÈÕÆÚ »õÆ· ÊýÁ¿
2009-12-01 aa 10
2009-12-03 aa 10

½á¹û±í£º
ÈÕÆÚ »õÆ· Èë²ÖÊýÁ¿ ³ö²ÖÊýÁ¿
2009-12-01 aa 20 10
2009-12-03 aa 20 10 
2009-12-04 bb 20 0

Çë½ÌÈçºÎÓÃSQLÉú³É½á¹û±í

---

SQL code:
select a.*,isnull(b.ÊýÁ¿,0) ÊýÁ¿
from Èë²Ö±í a
left join Èë²Ö±í
on a.»õÆ·=b.»õÆ· and a.ÈÕÆÚ=b.ÈÕÆÚ

---

ÒýÓÃ

SQL codeselect a.*,isnull(b.ÊýÁ¿,0) ÊýÁ¿from Èë²Ö±í aleftjoin Èë²Ö±íon a.»õÆ·=b.»õÆ·and a.ÈÕÆÚ=b.ÈÕÆÚ

SQL code:
select a.*,isnull(b.ÊýÁ¿,0) ÊýÁ¿
from Èë²Ö±í a
left join Èë²Ö±í b
on a.»õÆ·=b.»õÆ· and a.ÈÕÆÚ=b.ÈÕÆÚ

---

SQL code:
select
a.ÈÕÆÚ,a.»õÆ·,isnull(a.ÊýÁ¿,0) as Èë²ÖÊýÁ¿, isnull(b.ÊýÁ¿,0) as ³ö²ÖÊýÁ¿
from
Èë²Ö±í a
left join
³ö²Ö±í b
on
a.ÈÕÆÚ=b.ÈÕÆÚ

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.Co