2张表 如何一次性查出子表的count数？

[lijing3333]

数据如下
o.id o.title e.pid
196 12312 196
196 12312 196
197 fgdfg 197
198 234 198
199 234 199
200 3434 200
201 风刮大风 201
202 234 202
203 234 203

SELECT o.[id]
      ,o.[title],count(e.pid)	
  FROM  [dbo].[photo] o join [dbo].[photoList] e on o.[id] = e.[pid] group by o.[title]//我这个有错误 如何修改？

错误：因为该列没有包含在聚合函数或 GROUP BY 子句中。

我想得到的结果：

o.id o.title count
196 12312 2
197 fgdfg 1
198 234 1


求教了

[快溜]

SELECT o.[id]
      ,o.[title],count(e.pid)    
  FROM  [dbo].[photo] o join [dbo].[photoList] e on o.[id] = e.[pid] 
  group by o.[id],o.[title]

[-晴天]

SELECT o.[id]
      ,o.[title],count(e.pid)    
  FROM  [dbo].[photo] o join [dbo].[photoList] e on o.[id] = e.[pid] group by o.id,o.[title]//

[中国风]

group by o.[title],o.[id]--少了分組o.id

[--小F--]

SELECT
 o.[id],o.[title],count(e.pid)    
FROM 
 [dbo].[photo] o join [dbo].[photoList] e on o.[id] = e.[pid] 
group by
 o.[id],o.[title]