Posted by lukster on 10/01/72 11:42

Derived is exactly what I need,

thanks everyone for the prompt responses.

just in reponse to some of the comments:

Repeating wouldn't work because for what I'm doin' column 'c' is a
lengthy case statement which 4-5 other colums depend on, copy/pasting
that over and over woudl make the query unreadable.

why eleminate the views? I'd like to minimize the amount of views
because it's clutters my database, I'm well over 200 views now, most of
which are just intermediate steps, also. when working on the final view
I'd like to see all the steps at once, writing documentation for 5
views and having flip between them is annoying (especially with now
slow access is)

once again, thank you very much.

[Back to original message]