What types of relationships exist when using the join operation in SQL?

In SQL, the following types of joins exist:

• CROSS JOIN: Returns the Cartesian product of all rows from both tables.
• INNER JOIN (or just JOIN): Returns rows where there is a match in both tables based on the specified condition.
• LEFT OUTER JOIN (or LEFT JOIN): Returns all rows from the left table and matching rows from the right table. If there are no matches in the right table, the columns from it will contain NULL.
• RIGHT OUTER JOIN (or RIGHT JOIN): Returns all rows from the right table and matching rows from the left table. If there are no matches in the left table, the columns from it will contain NULL.
• FULL OUTER JOIN (or FULL JOIN): Returns all rows from both tables. If there is no match for a row in one of the tables, the corresponding columns will contain NULL.