mysql - MySQL 中的一个查询

Question

我想获取所有每小时付薪 17.5 的员工，项目名称是 HR System。

employee table: employee_id (PK), employee_name
project table: project_code (PK), project_title
project_team: project_code (FK), employee_id (FK), hourly_rate

我尝试了以下查询，但出现语法错误。我哪里做错了？

SELECT employee.`department_id`, employee.`employee_name`, project_team.`hourly_rate`, project.`project_title`
FROM
(employee INNER JOIN project_team ON employee.`employee_id` = project_team.`employee_id`)
AND
(project INNER JOIN project_team ON project.`project_code` = project_team.`project_code`)
AND
(project_team.`hourly_rate` = 17.50)
AND
(project.`project_title` = "HR System");

Answer 1

使用这个语句

SELECT employee.`department_id`, employee.`employee_name`, project_team.`hourly_rate`, project.`project_title`
FROM employee 
INNER JOIN project_team ON employee.`employee_id` = project_team.`employee_id`
inner join project ON project.`project_code` = project_team.`project_code`
where
(project_team.`hourly_rate` = 17.50)
AND
(project.`project_title` = "HR System");

您不能在 from 子句中使用 AND。您必须使用正确的 join 语法。