Match the following join types to their descriptions:
I. Unequal join
II. Inner join
III. Outer join
IV. Left outer join
V. Right outer join
A. can be created only in SQL view
B. used when you want to display all of the records on the one side of a one-to-many relationship
C. allows only the records where the value in a common field exists in both related tables to be displayed
D. used when you want to display all of the records on the many side of a one-to-many relationship
E. typically used to display records from both tables
A, C, E, B, D
Computer Science & Information Technology