What type of join compares tables and returns only the rows that have a matching value in a specified column?

Tools of the Trade: Linux and SQL | Weekly challenge 4 Quiz | 

What type of join compares tables and returns only the rows that have a matching value in a specified column?

  • FULL OUTER JOIN
  • LEFT JOIN
  • INNER JOIN
  • RIGHT JOIN

 

Leave a Comment