Refer to the exhibit. Match the JOIN operation with the proper description.
Explanation: Place the options in the following order:
| LEFT JOIN | Returns all records from Table 1 and only the matched records from Table 2. |
| FULL JOIN | Returns all records from Table 1 and Table 2. |
| RIGHT JOIN | Returns all records from Table 2 and the matched records from Table 1. |
| INNER JOIN | Returns only records where the selected fields have matching values in Table 1 and Table 2. |
Related exam: Data Analytics Essentials Course Final Exam
