general

[Former Member]

what is the use of selection conditions in views?

[Former Member]

It is same as the where clause of the select query.

[Former Member]

To restrict the data selected, selection conditions are use.

e.g.:- compare the the view creation with the select statement.

evrything will be clear to you.

select **** --> filed to select

from tab1 tab2 --> tables to join

on fied1 = field2 --> primary keys

where ****---> whatever comes in where condition are selection conditions

[Former Member]

Hai,

Selection Condtions makes reduced data(rows) satisying the conditons from the specified tables to be present in the view.

regds,

Rama.Pammi

[Former Member]

Hi,

Using the Selection Conditions we can give the Table and aFiedl name and the

Operator comparitive value followed by AND /OR operator.

using the selection Condition it will give the condition for that Veiw to get the Data

at the Run time.

It will act as the Where condition to fetch the selected condition values for the View.

Thanks & Regards,

Nelson

Rewar Poins if really helpfull