左连接

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