03-30-2007 5:39 PM
I created a view using 4 tables. If one of the tables doesn't contain data will the view be blank?
03-30-2007 6:12 PM
If it is a database table, with inner join, you wont read any record if one of the table is empty.
The other type of view use outer join, so you will get records filled with null values.
<i>Four different view types are supported. These differ in the way in which the view is implemented and in the methods permitted for accessing the view data.
Database views are implemented with an equivalent view on the database.
Projection views are used to hide fields of a table (only projection).
Help views can be used as selection method in search helps.
Maintenance views permit you to maintain the data distributed on several tables for one application object at one time.
Database views implement an inner join. The other view types implement an outer join (see Inner and Outer Join).</i>
Regards