Skip to content

Instantly share code, notes, and snippets.

@wilmoore
Last active July 13, 2024 23:35
Show Gist options
  • Select an option

  • Save wilmoore/f38f8f3248f8ee42dfa0baa8b83c11d7 to your computer and use it in GitHub Desktop.

Select an option

Save wilmoore/f38f8f3248f8ee42dfa0baa8b83c11d7 to your computer and use it in GitHub Desktop.
Software Engineering :: Database :: SQL :: Clause :: JOIN

Software Engineering :: Database :: SQL :: Clause :: JOIN

⪼ Made with 💜 by Polyglot.

related

The JOIN clause 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 Joins
  • CROSS JOIN
Inner Joins
  • INNER JOIN
Outer Joins
  • LEFT JOIN (or LEFT OUTER JOIN)
  • RIGHT JOIN (or RIGHT OUTER JOIN)
  • FULL JOIN (or FULL OUTER JOIN)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment