Refer to the exhibit. Match the JOIN operation with the proper description.
- 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.
| Explanation & Hint:
Place the options in the following order:
|