Alert Moderator

Add comment

You can only create databse view with inner join. But if you want to create a view with outer join you can create maintainence view for the same. Moreover, it is not recommended to use outer join in the view due to data inconsistency might raise in the Database.

A Database View always implements an Inner Join. If it is made from only a single table, then you can use it for maintainance also. But if you use a Maintainance View, then it implements an Outer Join.