Question

Name the type of join used to combine rows from two tables based on a related column between them.

Hint:

\textbf{Remember:} Matching rows from both tables → INNER JOIN.

Answer 1

Concept: In relational databases, joins are used to combine data from multiple tables using a common column. Different types of joins serve different purposes depending on how the data should be merged. Answer: The join used to combine rows from two tables based on a related column between them is called an INNER JOIN. Explanation:

An INNER JOIN returns only the rows that have matching values in both tables.
It uses a common column (such as an ID or key) to relate the tables.
Rows without matching values are excluded from the result.
Example: \begin{verbatim} SELECT * FROM Students INNER JOIN Marks ON Students.ID = Marks.ID; \end{verbatim} Result: Only students who have matching marks records will appear in the output. Other Types of Joins (for reference):

LEFT JOIN: All records from left table + matching from right.
RIGHT JOIN: All records from right table + matching from left.
FULL JOIN: All records from both tables.
Conclusion: An INNER JOIN is the standard method used to combine rows from two tables using a related column where matching values exist in both tables.