Posted by David Portas on 01/07/07 08:38

John Rivers wrote:
> create from dbo.fromExample
> as
> from dbo.Customers c
> join dbo.Invoices i
> on c.CustomerID = i.CustomerID
>
> now you can use it as follows:
>
> select c.CustomerID, i.InvoiceNo
> from dbo.fromExample
>
> I find I reuse FROM clauses alot
>
> and reusing a "base query" requires writing a very large and cumbersome
> select clause

Use a CTE
or a view
or a derived table

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

[Back to original message]