Posted by Ed Murphy on 01/09/07 16:25

Shuurai wrote:

> John Rivers wrote:
>> Thanks for your reply
>>
>> CTEs, Views and Derived Tables
>>
>> all require a SELECT clause
>>
>> what I am trying to achieve is a reusable FROM clause
>
> So essentially you want to avoid having to type "SELECT" and some
> column names?

I suppose he wants to avoid having to limit the common thing to certain
column names. Which he could do by creating a view that includes all
columns (renaming some as needed to avoid duplicate names), then doing
various SELECTs against that view.

[Back to original message]