Re: [GENERAL] Is this possible or am I on drugs :)

[Tod McQuillin]

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