let’s ‘JOIN’ in SQL

Joins : Retrieving data from two or more tables having common columns (primary-foreign key) Types of Joins: Equi join / Inner Join / Natural Join (most frequently used) In-equi join (use for exception reports) Outer join (Full outer join, left outer join, right outer join) Cartesian join/ cross join (fastest join - as no 'WHERE' …