[Solved] Given tables Staff and Teams with a common column TeamID, what does this query return?SELECT s.Name, t.TeamName FROM Staff s JOIN Teams t ON s.TeamID = t.TeamID; | SQL

SQL - INNER JOIN

Given tables Staff and Teams with a common column TeamID, what does this query return?

SELECT s.Name, t.TeamName FROM Staff s JOIN Teams t ON s.TeamID = t.TeamID;

AAll teams regardless of staff membership

BAll staff members regardless of team membership

COnly staff members who belong to a team with matching TeamID

DStaff and teams combined without any condition

Step-by-Step Solution

Solution:

Step 1: Understand INNER JOIN behavior
INNER JOIN returns rows where the join condition matches.
Step 2: Analyze the ON clause
Rows are matched where s.TeamID = t.TeamID.
Final Answer:
Only staff members who belong to a team with matching TeamID -> Option C
Quick Check:
INNER JOIN filters to matching keys only [OK]

Quick Trick: INNER JOIN returns only matching rows [OK]

Common Mistakes:

MISTAKES

Master "INNER JOIN" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Given tables Staff and Teams with a common column TeamID, what does this query return?