Types of Join:
1. Normal join: Returns the records present in both tables if there is at least one match between columns
2. Master outer join: Returns all the existing records from detail table and only matching records from master table.
3. Detail outer join: Returns all the existing records from Master table and only matching records from Detail table.
4. Full outer join: Returns all rows of data from both the master and detail sources.
Data Café 