Question

Which SQL join returns only the rows where there is a match in both tables based on the join PSC condition?

• A. NATURAL JOIN
• B. INNER JOIN
• C. OUTER JOIN
• D. CROSS JOIN

Answer 1

Answer:

B. INNER JOIN

• INNER JOIN statement returns only those records or rows that have matching values and is used to retrieve data that appears in both tables.
• In our example, we want to extract data from the Sales.