Software Engineering :: Database :: SQL :: Clause :: JOIN
⪼ Made with 💜 by Polyglot.
- Software Engineering :: Database :: SQL :: Command :: DML
- Software Engineering :: Database :: SQL :: Command :: DQL
- Software Engineering :: Database :: SQL :: Command :: DQL :: SELECT
The
JOINclause is used in SQL to combine rows from two or more tables based on a related column between them. It allows for querying data that spans multiple tables, providing a way to link tables together.
- CROSS JOIN
- INNER JOIN
- LEFT JOIN (or LEFT OUTER JOIN)
- RIGHT JOIN (or RIGHT OUTER JOIN)
- FULL JOIN (or FULL OUTER JOIN)