Posted by: informaticareference on: 12/07/2011
Normal (Default) – Only matching rows from both master and detail
Master outer – All detail rows and only matching rows from master
Detail outer - All master rows and only matching rows from detail
Full outer – All rows from both master and detail (matching or non matching)