select biz.付费商家流水号,area.子区域流水号,名字,特色图片,人气,温度 ,count(biz.付费商家流水号) from xl_付费商家 as biz inner join xl_storescore as ss on biz.付费商家流水号=ss.付费商家流水号 inner join Xl_子区域 as area on area.子区域流水号=biz.子区域流水号 group by biz.付费商家流水号,area.子区域流水号,名字,特色图片,人气,温度
select a.内容,count(b.评论人) from 新闻表 a ,品论表 b where a.新闻id = b.新闻id group by a.内容纯猜测
select biz.付费商家流水号,biz.子区域流水号,名字,特色图片,人气,温度 ,count(biz.付费商家流水号) ,area.名称 from xl_付费商家 as biz inner join xl_storescore as ss on biz.付费商家流水号=ss.付费商家流水号 inner join Xl_子区域 as area on area.子区域流水号=biz.子区域流水号 group by biz.付费商家流水号,biz.子区域流水号,名字,特色图片,人气,温度,area.名称
http://topic.csdn.net/u/20091130/21/fb718680-98ff-4afb-98d8-cff2f8293ed5.html?24281
select biz.付费商家流水号,area.子区域流水号,名字,特色图片,人气,温度
,count(biz.付费商家流水号)
from xl_付费商家 as biz
inner join xl_storescore as ss
on biz.付费商家流水号=ss.付费商家流水号
inner join Xl_子区域 as area
on area.子区域流水号=biz.子区域流水号
group by biz.付费商家流水号,area.子区域流水号,名字,特色图片,人气,温度
group by a.内容纯猜测
,count(biz.付费商家流水号)
,area.名称
from xl_付费商家 as biz
inner join xl_storescore as ss
on biz.付费商家流水号=ss.付费商家流水号
inner join Xl_子区域 as area
on area.子区域流水号=biz.子区域流水号
group by biz.付费商家流水号,biz.子区域流水号,名字,特色图片,人气,温度,area.名称