下面这个SQL语句怎么修改呀

Question

select com_employee.empl_code Doctorid,com_employee.empl_name Doctorname, (case when com_employee.sex_code='F'then '男' else '女' end) as Doctorsex,
dawn_org_empl.LEVL_CODE Dotortitle, dawn_org_empl.EMPL_DESC Doctorcompany, fin_opr_schema.id Departmentid,
dawn_org_dept.DEPT_NAME from com_employee, dawn_org_empl, fin_opr_schema, dawn_org_dept;
本来这个SQL语句可以运行出来，但是我发现ID和名字有重复值
所以要根据com_employee.empl_code来进行去重
但我改来改去老是报错😭

Answer 1

该回答引用chatgpt:

SELECT com_employee.empl_code Doctorid, com_employee.empl_name Doctorname,
       CASE WHEN com_employee.sex_code='F' THEN '男' ELSE '女' END AS Doctorsex,
       dawn_org_empl.LEVL_CODE Dotortitle, dawn_org_empl.EMPL_DESC Doctorcompany,
       fin_opr_schema.id Departmentid, dawn_org_dept.DEPT_NAME
FROM com_employee
JOIN dawn_org_empl ON com_employee.empl_code = dawn_org_empl.empl_code
JOIN fin_opr_schema ON dawn_org_empl.ORG_CODE = fin_opr_schema.org_code
JOIN dawn_org_dept ON fin_opr_schema.dept_code = dawn_org_dept.DEPT_CODE
GROUP BY com_employee.empl_code;