这个SQL语句不对,如何修改?
select [tb_estimation].PID,Title,Author,UserID,UploadDate,SubDate,Field1,Field2,Field3 from [tb_estimation],[tb_paper] where [tb_paper].PID=[tb_estimation].PID and HaveUsed='N' Group By [tb_estimation].PID Having count(distinct [tb_estimation].EID)=5
错误是列 'tb_paper.Title' 在选择列表中无效,因为该列既不包含在聚合函数中,也不包含在 GROUP BY 子句中!!