True or False: All rows from both tables are returned in an INNER JOIN

True or False: All rows from both tables are returned in an INNER JOIN
A . True
B . False

View Answer

Answer: B

Explanation:

The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns. Consider 2 tables "Orders" and "Customers".

If there are records in the "Orders" table that do not have matches in "Customers", these orders will not be shown!

Reference: https://www.w3schools.com/sql/sql_join_inner.asp