Which of the following joins compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause?
A)inner
B)outer
C)nested
D)product

Question

Which of the following joins compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause?​
A)inner
B)​outer
C)nested
D)​product

Quizplus · Accepted Answer

The inner join compares the tables in the FROM clause and retrieves only those rows that satisfy the condition mentioned in the WHERE clause. It returns only the matching rows from both the tables. The outer join, on the other hand, includes all the rows from one table and only matching rows from the other table, if any. The nested and product joins are not standard types of joins.

Which of the Following Joins Compares the Tables in the FROM Clause