Left Join vs Right Join | Dataford Interview Questions

What is the difference between a left join and a right join?

Use the tables provided to return the joined rows for the specified join type. Rows with a NULL in the join key are ignored.

Output

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee 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 Left Join vs Right 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.

What is the difference between a left join and a right join?

Use the tables provided to return the joined rows for the specified join type. Rows with a NULL in the join key are ignored.

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee 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 Left Join vs Right 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.