How do you join tables in SQL?

In SQL, you join tables using the JOIN clause, which allows you to combine rows from two or more tables based on a related column. The most common types of joins are INNER JOIN, which returns rows with matching values in both tables; LEFT JOIN, which returns all rows from the left table and matched rows from the right table; and RIGHT JOIN, which does the opposite. You specify the joining condition using the ON keyWord, typically comparing primary and foreign keys. For example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.foreign_id;.