You have two tables, employees (left table) and departments…
You have two tables, employees (left table) and departments (right table).You run the following query: SELECT e.id, e.name, d.department_nameFROM employees eLEFT JOIN departments dON e.department_id = d.idWHERE d.id IS NULL; What does this query return?
Read Details