SQL JOINS

What are SQL joins? Well, there are several different types of joins and they are used to retrieve data between two different tables.

• INNER JOIN: Retrieves the records between the tables, that satisfy the join condition.
• LEFT JOIN: Retrieves the records of table ‘A’ and only records of table ‘b’ that satisfy the join condition.
• RIGHT JOIN: Retrieves the records of table ‘B’ and only records of table ‘A’ that satisfy the join condition.
• FULL OUTER JOIN: Retrieves all records of table ‘A’ and ‘B’ into one table