With appropriate indexes, this should be quite efficient enough:
SELECT tb3.employee_name, (salary+bonus) remuneration
FROM tb3
LEFT JOIN tb1
ON tb1.employee_name = tb3.employee_name
LEFT JOIN tb2
ON tb2.employee_name = tb3.employee_name
连续 两个 LEFT JOIN LEFT JOIN
最新推荐文章于 2023-10-18 11:33:23 发布