(self,left outer,right outer,full outer) join - real world examples?
Have a look at, which contains explenations and examples.
Related Questions
Basic Question : LEFT OUTER JOIN vs Left Join?
Self.tableView.delegate = self and self.table.dataSource = self memory leak?
LINQ to SQL - Left Outer Join with multiple join conditions?
SQL Left Outer Join doesn't give full table?
Left Outer Join Does not preserve Left Table?
Left join or right join in a MySQL query?