Which query will return only the employees who are assigned to a department that exists in the departments table?

Question

Answer

a.  SELECT emp_name, dept_name 
 FROM employees 
 WHERE dept_id IS NOT NULL;

Answer

d.  SELECT emp_name, dept_name 
 FROM employees 
 RIGHT JOIN departments ON employees.dept_id = departments.dept_id;

Answer

c.  SELECT emp_name, dept_name 
 FROM employees 
 INNER JOIN departments ON employees.dept_id = departments.dept_id;

Answer

b.  SELECT emp_name, dept_name 
 FROM employees 
 LEFT JOIN departments ON employees.dept_id = departments.dept_id;

Crowdly