create view v1
as
select a.id, a.name, count(b.*) as 评论的总数
from a, b
where a.id = b.a_id
group by a.id, a.name
as
select a.id, a.name, count(b.*) as 评论的总数
from a, b
where a.id = b.a_id
group by a.id, a.name
调试欢乐多
'*'号附近有语法错误...
from a
left join (select a_id,count(*) as times from b group by a_id) b
on a.id = b.a_id