mysql - mysql从具有功能的多个表中选择

此查询的主要问题是什么

select reports.SUM( time1 ),
reports.created_by,
reports.id,
users.wage,
users.title
from reports,
users
where users.title = reports.created_by
and reports.created_date >= '1396/03/01'
and reports.created_date <= '1396/03/30'
GROUP BY created_by
ORDER BY created_by

1630-功能报告。SUM不存在。检查参考手册中的“函数名称解析和解析”部分

最佳答案

它应该是 ...

select SUM(reports.time1),
reports.created_by,
reports.id,
users.wage,
users.title
from reports,
users
where users.title = reports.created_by
and reports.created_date >= '1396/03/01'
and reports.created_date <= '1396/03/30'
GROUP BY created_by
ORDER BY created_by

关于mysql - mysql从具有功能的多个表中选择，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/44623978/

Reports

mysql - mysql从具有功能的多个表中选择