With the use of outer join you can join the tables even there is no entry in all the tables used in the view. In the case of an inner join, there should be an entry in all the tables use in the view.
