VIEW Error

[vallamuthu_madheswaran2]

Hi Friends,

I am creating a VIEW in combination of 3 HR Tables.

in selection condition i am using PAYGRUP GE '120' but it fetch all the data

PAYGRUP CHAR 8.

KINDLY HELP ME.

Thanks & Regards,

Vallamuthu.M

[Former Member]

hi

The condition is okay since your operand is within quotes ( character handling).

you may have to check if there is a inner-join needed for the right data.

Thanks.

[Former Member]

Hi ,

for you creation you must be logically correct ,

example is

table1.

table2,

table 3, -> this table is having Paygroup .

then in the view .

table order should be

table3,
table1 or table2  based  on the  next  select  Condition , then 
table 1 or table2  which ever  is left .

so that in the join

first

table3-field1  =  table1-field1.
table3-paygroup = table1-paygroup. 
table3-paygroup = table2-paygroup.

try this ,

Reward points if it is usefull .....

Girish