Views (again) in 8.1.7

Hi All,

I looked in the archives but found no solution for my simple problem. I receive an error when I select the TOTAL column from my view. How can I resolve this???

create view v_tot as select fld1,fld2+fld3 "tot" from table1;

select fld1,tot from v_tot;

the error is on: tot

All help is greatly appreciated.
Maarten Received on Wed May 15 2002 - 22:52:32 CEST