Which of the following joins will you use to display data that do not have an exact match in the column?
Non-equijoin
Correct:
Non-equijoin
Explanation:
Answer option D is correct.
In non-equijoin, a query relates two tables using an operator other than the equality operator (=). As you have to display data that do not have an exact match in the column, you will use an operator other than the equality operator (=). Hence, you will use non-equijoin.
Answer option C is incorrect. Outer join returns all rows from one table and only the matching rows from the joining table.
Answer option B is incorrect. When a query relates two tables using an equality operator (=), it is known as inner join or equijoin.
Answer option A is incorrect. Self join is made on a single table. Each row of the table is combined with itself and with every other row of the table.