What does INNER JOIN do?

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

What does INNER JOIN do?

  • Compare tables and return only the rows that have a matching value in a specified column
  • Filter databases to return only columns that exist in every table
  • Combine tables and save them as a new table
  • Return every row in joined tables

 

Leave a Comment