Two tables related by a common field with the same value in the common field in each table is an example of a(n)____ join.
A)inner
B)outer
C)self
D)related

Question

Quizplus · Accepted Answer

An inner join is used when we want to retrieve only the data that has a match in both tables based on a common field. In this case, both tables have a common field with the same value, and therefore an inner join would be appropriate to retrieve the data that satisfies this condition. Outer join retrieves all the data from one table and only the matching data from another table. Self join is used to join a table with itself to produce a result set that joins rows with other rows within the same table using the comparison operators (=, <>, <, <=, >, >=). The term "related join" is not a commonly used term in database management.

Two Tables Related by a Common Field with the Same