SELECT
emp_id, emp_name, gender, email, d_id ,dept_id,dept_name
FROM tbl_emp
LEFT JOIN tbl_dept ON tbl_emp.d_id=tbl_dept.dept_id
本文标题：左连接
本文链接：https://www.haomeiwen.com/subject/evgjjxtx.html
网友评论