Inner Join Explanation | Dataford Interview Questions

Describe an inner join.

Use the provided worker and assignment data to demonstrate the concept with a query. Return only records where a worker has a matching assignment.

Output

One row per matching worker-assignment pair
Columns: worker_name, assignment_id, assignment_name, and assignment_status
Exclude workers without assignments and assignments without workers; order by worker_name, then assignment_id

workers

assignments

Column	Type	Description
assignment_idPK	INT	Unique assignment identifier
worker_id	INT	Worker assigned to the work item
assignment_name	VARCHAR(120)	Assignment name
assignment_status	VARCHAR(30)	Current assignment status

Your question is Inner Join Explanation. 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.

Describe an inner join.

Use the provided worker and assignment data to demonstrate the concept with a query. Return only records where a worker has a matching assignment.

One row per matching worker-assignment pair
Columns: worker_name, assignment_id, assignment_name, and assignment_status
Exclude workers without assignments and assignments without workers; order by worker_name, then assignment_id

workers

assignments

Column	Type	Description
assignment_idPK	INT	Unique assignment identifier
worker_id	INT	Worker assigned to the work item
assignment_name	VARCHAR(120)	Assignment name
assignment_status	VARCHAR(30)	Current assignment status

Your question is Inner Join Explanation. 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.