Both an employees table and a machines table contain an employee_id column, and you want to return only the records that share a value in this column. Which keyword should be part of your query?

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

Both an employees table and a machines table contain an employee_id column, and you want to return only the records that share a value in this column. Which keyword should be part of your query?

  • FULL OUTER JOIN
  • INNER JOIN
  • BETWEEN
  • WHERE

 

Leave a Comment