The Seven Types of SQL Joins
It’s unlikely that you’ll be working exclusively with data from one table. So, you need to be able to grab data from multiple tables. One of the ways to do this is by using joins. In relational databases, joins are what make relational databases relational. This post provides a quick refresher of the four main types of SQL Joins and three of its variants.
What is a join?
A SQL join is a Structured Query Language (SQL) way of linking data from two or more tables based on a column shared ...