Joins
Simple or Inner Join: Fetch the record only matched rows from primary table and secondary table. Right Outer Join: Fetch the record matched rows from primary table and secondary table and unmatched rows from the secondary table. Left Outer Join: Fetch the record matched rows from both table primary and secondary table and unmatched rows from primary table.