Posted by lukster on 06/19/65 11:42

Hello There,

I'm trying to create a view that has calculations dependent on
calculations, where the problem resides is that each time I make a
calculation I must create an intermediate view so I can reference a
previous calculation.

for example lets say I have my_table that has columns a & b. now I want
a view that has a & b, c = a + b, and d = c + 1.

this is grossly simplified, the calculations I actually use are fairly
complex and copying / pasting them is out of the question.

so what I have is my_view_a which makes column c, and my my_view_final
which makes column d (however, in my real application I have 5 of these
views, a/b/c/d/e/)

is there anyway I can consolidate all these views into one? I was
thinking of using a stored procedure with temp tables or something
along those lines.

I just which I can use the aliases that I create for c in d in one
step.

any insight would be greatly appreciated.

[Back to original message]