SQL Join Across Two Tables | Dataford Interview Questions

Write a SQL query to fetch details of an employee from two tables using joins.

Use the employees and departments tables. Return every employee, including employees whose department is missing or does not have a matching department record. Include the employee's department name and office location when available.

Output

One row per employee
Columns: employee_id, employee_name, job_title, department_name, and office_location
Sort by employee_id in ascending order

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee full name
job_title	VARCHAR(100)	Employee job title
department_id	INT	Department identifier associated with the employee

departments

Column	Type	Description
department_idPK	INT	Unique department identifier
department_name	VARCHAR(100)	Department name
office_location	VARCHAR(100)	Primary office location for the department

Your question is SQL Join Across Two Tables. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem