Describe a SQL Join | Dataford Interview Questions

What is a join in SQL?

Asked in the Aptitude Test stage. Listed under Round 1 together with git commands.

Write a SQL query that associates each employee with the matching department name when available.

Output

Return one row per employee with employee_id, employee_name, and department_name.
Include employees without a matching department, using NULL for department_name.
Order by employee_id ascending.

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee full name
department_id	INT	Department assigned to the employee

departments

Column	Type	Description
department_idPK	INT	Unique department identifier
department_name	VARCHAR(100)	Department name

Your question is Describe a SQL Join. 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.