FROM employees e RIGHT JOIN projects p ON e.emp_id = p.emp_id; select e.emp_id,e.emp_name, e.department,e.city,p.project_id,p.project_name, p.project_budget,p.project_status FROM employees e left join ...