Re: Is this possible or am I on drugs :)

On Mon, 27 Nov 2000, shawn everett wrote:

> select colA, colB, colA+colB*0.4 as f1, colC, colC+colD*9 as f2 from table
> where date=SomeDateEnteredByTheUser;

CREATE VIEW v1 AS
select colA, colB, colA+colB*0.4 as f1, colC, colC+colD*9 as f2, date
from table;

SELECT colA, colB, f1, colC, f2
FROM v1 where date=SomeDateEnteredByTheUser;
--
Tod McQuillin