The set of data that can be selected with a view greatly depends on whether the view implements an inner join or an outer join.With an inner join, you only get those records which have an entry in all the tables included in the view. With an outer join, on the other hand, those records that do not have a corresponding entry in some of the tables included in the view are also selected.
The hit list found with an inner join can therefore be a subset of the hit list found with an outer join.Database views implement an inner join. You only get those records which have an entry in all the tables included in the view.
Maintenance views implement an outer join.
RELATED POSTS
SEARCH HELP
CHANGING DATA BASE TABLES IN SAP DAY 16The hit list found with an inner join can therefore be a subset of the hit list found with an outer join.Database views implement an inner join. You only get those records which have an entry in all the tables included in the view.
Maintenance views implement an outer join.
RELATED POSTS
SEARCH HELP
SEARCH HELP USING ABAP DAY 18
No comments :
Post a Comment