view & innerjoin ?

[Former Member]

what is the difference between view & innerjoin ?explain plz ?

[Former Member]

Spart Cus,

You are asking lots of questions... are points getting rewarded?

[KjetilKilhavn]

> Spart Cus,

>

> You are asking lots of questions... are points

> getting rewarded?

Spart Cus is using the performance & tuning forum as his/her personal teacher. She/He is preparing for job interviews I guess, and wants to give the impression of being a programmer with at least some experience.

The really sad thing is that people respond to the questions. These questions don't belong in the performance & tuning forum, but by answering them everyone is encouraging this behaviour to be continued. I have better things to do than teach beginners what they can teach themselves by reading online help or spending a few hours experimenting in a small test program. If this forum continues to be filled with repeated questions about inner join vs. for all entries, and (stupid) beginner questions I don't think I will be a guest here any more.

I know the same problem exists in other forums, and some of the most experienced people now spend less time in the SDN forums. They just don't have that much time to spare. That means when the really tricky problems come up there won't be many people around to answer. Sad, but that's the way it goes when we allow the exploiters to have it their way.

[Former Member]

innerjoin

The data that can be selected with a view depends primarily on whether the view implements an inner join or an outer join. With an inner join, you only get the records of the cross-product for which there is an entry in all tables used in the view. With an outer join, records are also selected for which there is no entry in some of the tables used in the view.

The set of hits determined by an inner join can therefore be a subset of the hits determined with an outer join.

Database views implement an inner join. The database therefore only provides those records for which there is an entry in all the tables used in the view. Help views and maintenance views, however, implement an outer join.

view

A view describes the layout and behavior of a rectangular area of a user interface.

Use

Every Web Dynpro application has at least one view. The layout of a view is made up of different user interface elements, which can be nested in each other. The positioning of interface elements in one view is supported by the supplied layout variants.

In addition to the visible part, the layout, a view also contains a controller and a context. The data to which the elements of the view can be bound are stored and managed in the view context, enabling them to be represented or used on the screen. The view controller can contain methods for data retrieval or for processing user input.

Multiple views can be classified in view sets.

A view also has inbound and outbound plugs so that views can connected with each other, or so that a view can be linked with an interface view. These plugs can be linked with each other using navigation links.

Empty View

The empty view is a special type of view. It is always generated automatically in a window or a view set area, provided that no view has been embedded manually. It may also be preferable to embed an empty view in a non-empty window as well. Just like a normal view, the empty view occupies a certain area of a window at runtime and can be used to hide a different view, for example, using specific controls.

When you create an empty view, an inbound plug with the default name ShowEmptyView is created.

[Former Member]

Hi Spart

suppose if u have a join condition and u want to use this same in different number of objects then simply create a view for this type of situations

if u r creating a view in se11 here u can join the tables with out any coding easily and in program u can select data directly from view...

but in a program u have to create a join condition u have to write code but in views there is no need to write code

reward points to all helpful answers

kiran.M

Message was edited by:

Kiran Machavarapu

[seshatalpasai_madala]

Hi,

VIEW uses some kind of JOIN either INNER JOIN or OUTERJOIN.

Database views use INNER JOIN

Maintenance views use OUTER JOIN.

Regards,

Sesh