ÇóÒ»¸öSQLÓï¾ä-----ÔÚÏߵȴý

¸÷λÎÒÓÐÁ½Õűí a (id,title,important) , b (id,uid,content,newdate);
a table Êý¾ÝÈçÏÂ:
1  test1  1
2  test2  0
3  test3  1
4  test1  0

b table Êý¾ÝÈçÏÂ:
1  jason  content1  2009/1/1
1  ally  content1  2009/10/1
1  jason  content2  2009/10/4
2  alan  content1  2009/2/1
2  tony  content1  2009/12/25
2  jason  content1  2009/11/29

ÎÒÏëÒªµÃµ½ÕâÑùÒ»¸ö½á¹û:ͳ¼Æb±íÖÐÏàͬµÄidÓжàÉÙ¸ö,ͬʱ°Ña±íÖеÄtitleºÍimportantÁ½¸ö×Ö¶ÎÒ²ÏÔʾ³öÀ´.ÏëÒªµÄÊÇÕâÑùÒ»¸öЧ¹û:
id  title  important  qty
1  test1  1          3
2  test2  0          3

ÈçºÎдÕâ¸öSQLÓï¾ä?????

---

SQL code:

select c.id,a.title,a.important,c.qty
from
(
select id,count(*) as qty
from b
group by id
) c left join a on c.id=a.id

---

where ÉÙÁËe
¼Óµã ¡£¡£¡£¡£¡£¡£¡£²»¶ÌÁË

---

SQL code:
--> Title : Generating test data [ta]
--> Author : Wufeng4552
if object_id('[ta]') is not