Left join & inner join

Join helps you to get the details from two to more than two tables. Types Of join : 1.) Inner join 2.)Outer join 2.a) left Outer join 2.b) Right Outer Join 2.c) Full Outer Join3.)Cross Join 4.)Self join

Joins are used in queries to explain how different tables are related. Joins also let you select data from a table depending upon data from another table. Types of joins: INNER JOINs, OUTER JOINs, CROSS JOINs. OUTER JOINs are further classified as LEFT OUTER JOINS, RIGHT OUTER JOINS and FULL OUTER JOINS.