ÇóÒ»ÌõSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

ÓбíA£ºA_ID,A_Value
±íB£ºB_ID,B_A
±íC£ºC_ID,C_A
ÆäÖÐB_A×÷ΪÍâ¼ü¹ØÁªµ½A_ID£¬C_A×÷ΪÍâ¼ü¹ØÁªµ½A_ID¡£B_AºÍC_A¾ù¿ÉÄÜΪNULL¡£

ÏÖÔÚÏëÓÃÒ»ÌõSQLÓï¾ä²éѯ³öA_ID,A_Value,ÒÔ¼°B±íÖÐB_AµÈÓÚA_IDµÄ¼Ç¼×ÜÊý£¬C±íÖÐC_AµÈÓÚA_IDµÄ¼Ç¼×ÜÊý¡£
α´úÂ룺
SELECT A_ID,A_Value,COUNT(B.*) WHERE B_A=A_ID,COUNT(C.*) WHERE C_A=A_ID from A

Õâ¸öÓ¦¸ÃÔõôдÄØ£¿

---

SQL code:
SELECT A_ID,COUNT(B.B_A)AS NUM1,COUNT(C_A)AS NUM2
from A ,B,C WHERE A.A_ID=B.B_a
AND A.A_ID=C.C_A
GROUP BY A_ID

---

SQL code:
select a.*,(select count(1) from b where b_a=aa.a_id) bÊý,(select count(1) from c where c_a=aa.a_id) cÊý
from a aa

---

ÒýÓÃ

SQL code
SELECT A_ID,COUNT(B.B_A)AS NUM1,COUNT(C_A)AS NUM2
from A ,B,C WHERE A.A_ID=B.B_a
AND A.A_ID=C.C_A
GROUP BY A_ID

up

---

SQL code:
select A.A_ID,A.A_Value,COUNT(b.B_A) as B_A_Count,COUNT(c.C_A) as C_A_Count
from tbA as a
left join tbB as b
on a.A_ID=b.B_A
LEFT JOIN tbC as c
on A.A_ID=c.C_A
group by A.A_ID,A.A_Value

---

SQL code

---

Code highlighting produced by Actipro Co