Question

Which of the following is also called an INNER JOIN?

Select the correct answer from below options:

a) SELF JOIN

b) EQUI JOIN

c) NON-EQUI JOIN

d) None of the above

Answer 1

b) EQUI JOIN

The INNER JOIN returns data from the two or more tables that match the specified condition and hides other records. EQUI JOIN is similar to INNER JOIN that returns records for equality or matching column(s) values of the relative tables.