Joins in SQL
A JOIN clause in SQL is used to combine the records/rows from two or more tables, based on a common column that is present in the two tables. It creates a set that can be saved as a table or used as it is. They are predominantly used when a user is trying to extract data from tables that have one-to-many or many-to-many relationships between them. Following are the types of SQL Joins: 1. Inner Join The Inner Join in SQL keyword selects all the common rows from each the tables which satisfies the given condition. 2. Left Join This Left Join returns all the rows from the left table (Table 1) and the matched records from the right table (Table 2). The result is NULL from the right side table if there is no match in Table 2. 3. Right Join This Right Join returns all the rows from the right table (Table 2) and the matched records from the left table (Table 1). The re