来个高人~~ 关于SQL的3张表的整合~~ 在线等 ~

[q49442315]

1.select store.id,storename ,store.returnstate
as rate ,count(comments.storeid)
as commentcount from store

left join comments on
comments.storeid=store.id
group by store.id
order by rate asc


2.select store.id, count(banner.storeid)
as bannercount from store

left join banner on
banner.storeid=store.id
group by store.id
order by id asc

只要在一个查询结果集里面显示count(comments.storeid)，count(banner.storeid)，store.id，store.storename就可以了

[永生天地]

select 
count(comments.storeid),count(banner.storeid),store.id,store.storename

from store left join comments on
comments.storeid=store.id
left join banner on
banner.storeid=store.id
group by store.id
order by rate,id 

[pt1314917]

select a.id,a.storename,a.commentcount,b.bannercount from 
(select store.id,storename,count(comments.storeid)as commentcount from store
left join comments on comments.storeid=store.id
group by store.id)a,
(select store.id, count(banner.storeid)as bannercount from store
left join banner on banner.storeid=store.id
group by store.id)b
where a.id=b.id

[永生天地]

。。。今天忘吃药了
[Quote=引用 1 楼 xys_777 的回复:]
SQL code
select
count(comments.storeid),count(banner.storeid),store.id,store.storename

from store left join comments on
comments.storeid=store.id
left join banner on
banner.storeid=store.id
……
[/Quote]