¹ØÓÚSQLµÄÊýÁ¿Í³¼ÆÎÊÌâ

ͬһ¸öÊý¾Ý¿âµÄ

ÓÐÁ½¸ö±íAºÍB

A.idÊÇ×Ô¶¯±àºÅµÄ£¬B.urlµÈÓÚA.id

ÏÖÔÚÏëÖªµÀÂú×ãA.id=B.urlµÄÊýÁ¿,¾ßÌåµã½²¾ÍÊÇÏëÇó£º
µ±A.id=1ʱ£¬B.url¹²Óм¸ÌõÐÅÏ¢Ò²ÊǵÈÓÚ1£»µ±A.id=2ʱ£¬B.url¹²Óм¸ÌõÐÅÏ¢Ò²ÊǵÈÓÚ2¡¢¡¢¡¢


ÎÒÓÃ
SELECT count(*) as num
from A,B
WHERE A.id=B.url


¿ÉÊÇʧ°ÜÁË£¬ÇëÎÊÓÐʲô°ì·¨¿ÉÒÔ×öµ½Âð£¿

---

select a.*,b.num from tb a left join (select count(*) as num,url from btb group by url) b on a.id=b.url

---

select country£¨*£© from b where b.url=a.id

---

²éѯÓï¾äÊÇÕýÈ·µÄ
»Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡

---

ÒýÓÃ

<br /> select a.*,b.num from <span style="color:#FF0000">tb a left </span>join (select count(*) as num,url from <span style="color:#FF0000">btb group </span>by url) b on a.id=b.url <br />

ºìÉ«µÄÁ½¸öµØ·½Ã»¿´¶®£¬ÄܽâÊÍÒ»ÏÂÂð

---

select a.*,b.num from tb a left join (select count(*) as num,url from btb group by url) b on a.id=b.url

ºìÉ«µÄÁ½¸öµØ·½Ã»¿´¶®£¬ÄܽâÊÍÒ»ÏÂÂð

---

˵Ã÷һϣ¬ÒªÇóµÄÎÊÌâ´ó¸ÅÊÇÕâÑù×ÓµÄ:
A.id=B.url=1µÄÐÅÏ¢µÄÊýÁ¿£»
A.id=B.url=2µÄÐÅÏ¢µÄÊýÁ¿£»
A.id=B.url=3µÄÐÅÏ¢µÄÊýÁ¿£»
¡­¡­

ÇóµÄÊǸ÷×ÔµÄÊýÁ¿£¬²»ÊÇ×ÜÊý

---

SELECT count(*) as num
from A,B
WHERE A.id=B.url group by a.id

---

»¹ÊDz»ÐУ¬ÎÒÔÙ˵Ã÷һϣº

±íA£ºid  name