Write an Inner Join | Dataford Interview Questions

Write an inner join between an Emp table (emp id, emp name, emp dept id) and a Dept table (dept id, dept name) and describe its output.

Use the provided tables and return only employees with a matching department. Explain which rows are excluded when no matching department exists.

Output

emp

Column	Type	Description
emp_idPK	INT	Unique employee identifier
emp_name	VARCHAR(100)	Employee name
emp_dept_id	INT	Department identifier assigned to the employee

dept

Column	Type	Description
dept_idPK	INT	Unique department identifier
dept_name	VARCHAR(100)	Department name

Your question is Write an Inner 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.

Write an inner join between an Emp table (emp id, emp name, emp dept id) and a Dept table (dept id, dept name) and describe its output.

Use the provided tables and return only employees with a matching department. Explain which rows are excluded when no matching department exists.

emp

Column	Type	Description
emp_idPK	INT	Unique employee identifier
emp_name	VARCHAR(100)	Employee name
emp_dept_id	INT	Department identifier assigned to the employee

dept

Column	Type	Description
dept_idPK	INT	Unique department identifier
dept_name	VARCHAR(100)	Department name

Your question is Write an Inner 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.