这是我的选择查询，我想从同一张表中获取父级职员名称。
SELECT
master.staffId,
master.name,
DATE_FORMAT(master.joinDate,'%d-%m-%Y') AS joinDate,
master.commission,
master.salary,place AS placeName,
staffType,parent.name AS parentName
FROM
staff AS master
LEFT JOIN place
ON place.placeId = master.placeId
LEFT JOIN stafftype
ON stafftype.staffTypeId = master.staffTypeId
left outer join staff AS parent
ON parent.staffId = master.staffId
ORDER BY name
在查看您的评论时，我认为您需要这个
SELECT master.staffId,master.name,DATE_FORMAT(master.joinDate,'%d-%m-%Y') AS joinDate,master.commission,
master.salary,place AS placeName,staffType,parent.name AS parentName
FROM staff AS master
LEFT JOIN place ON place.placeId = master.placeId
LEFT JOIN stafftype ON stafftype.staffTypeId = master.staffTypeId
left outer join staff AS parent ON parent.staffId = master.parentStaffId
ORDER BY name
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句