Question

Which of the following is not a type of JOIN in SQL?

• A. EQUIJOIN
• B. NON EQUIJOIN
• C. INNER JOIN
• D. OUTER JOIN

Answer 1

Answer: (C)

INNER JOIN

INNER JOIN is not a type of JOIN in SQL.

INNERJOIN: Returns records that have matching values in both tables. LEFT (OUTER) JOIN: Return all records from the left table, and the matched records from the right table.

The INNER JOIN selects all rows from both participating tables as long as there is a match between the columns. An SQL INNER JOIN is same as JOIN clause, combining rows from two or more tables.