Match the following terms to their definition:
I.INNER JOIN
II.OUTER JOIN
III.FULL JOIN
IV.Union query
V.SQL subquery
A.Returns only the rows that actually match
B.Returns all rows from both tables
C.Usually added in the WHERE clause
D.Returns all rows from at least one of the tables
E.Combines two SQL SELECT statements

Question

Quizplus · Accepted Answer

The Answer of Match the following terms to their definition:
I.INNER JOIN
II.OUTER JOIN
III.FULL JOIN
IV.Union query
V.SQL subquery
A.Returns only the rows that actually match
B.Returns all rows from both tables
C.Usually added in the WHERE clause
D.Returns all rows from at least one of the tables
E.Combines two SQL SELECT statements

Match the Following Terms to Their Definition