Getting down to the use of join, using SQLite.

When learning SQL, aka Structured Query Language, one of the most important concepts to gain an understanding of, is using joins. In this blog, I will break down the different join types, why they are relevant, and how you may implement them yourself.

Just a quick recap, SQL helps us handle data with relational databases. When it comes to having different tables in a database, we need to find a way to connect the tables’ data, and this is where joins come in to save the day!

What are Joins?

Among the different tables, we can use a JOIN keyword to connect our tables to each other. Typically you will see joins used when there is a one-to-many or many-to-many relationship between tables.

There a couple of different types of joins:

•Inner join

•Left join

•Right join

•Full join

#database #sql