Final answer:
The task is to find study units with fewer credit points than INFO2120. An INNER JOIN is the most suitable option if comparing across different tables, but a simple SELECT with a WHERE clause may suffice if all data is in one table.
Step-by-step explanation:
The question asks to find all units of study that have fewer credit points than the course INFO2120. To achieve this, you would need to perform a comparison between the credit points of INFO2120 and other courses within a database. If we are assuming INFO2120 is a specific course within a table, we would use a SQL query with a JOIN operation to compare credit points across different rows (representing different courses).
To find courses with fewer credit points than INFO2120, the most suitable option could be an INNER JOIN, assuming we have two tables: one with course details including credit points, and another with related information where INFO2120 is present. The INNER JOIN will return rows where there is a match in both tables, and we can use a WHERE clause to filter courses with fewer credit points than INFO2120.
However, if INFO2120 and credit points are in the same table, you might not even need to use a JOIN. A simple SELECT statement with a WHERE clause comparing credit points would suffice. The other JOIN types like LEFT OUTER JOIN, RIGHT OUTER JOIN, or FULL OUTER JOIN are typically used for wider data comparison and merging purposes and might not be necessary if we are strictly looking for courses with fewer credit points than a specific course within the same table.