How can you join two tables in SQL using a column they both have in common?

  • CROSS JOIN
  • INNER JOIN
  • OUTER JOIN
  • SELF JOIN
The INNER JOIN keyword is used to combine rows from two tables based on a related column. This type of join returns only the rows where there is a match in both tables, based on the specified common column. OUTER JOIN, CROSS JOIN, and SELF JOIN serve different purposes in SQL join operations.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *