SQL Database Joins

If you work with multiple tables at the same time, there is a high chance you will need to join then through queries. In relational databases, we do this by using Left Joins, Right Joins, Outer Joins and  Inner Joins. Since there are so many options, the question is, which join to use in what scenario. Because if used incorrectly, the queries from these joins can produce erroneous data.