Posts

Showing posts with the label joins

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.