Tableau Desktop Specialist · Free Practice Question Easy

Question 9

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

  • A

    False

  • B

    True

Reveal correct answer

Correct answer: A

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

Discussion

Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.

You must be logged in to post a comment.

Preparing For

Your Certification?

255+ certifications
Detailed explanations
Free PDF samples

Has All The Questions You Need