Hari
3/28/2007 3:34:00 AM
Hello,
Use SELECT * INTO FROM Table syntax to create table from a query.
SELECT Col1,Col2,Col3 INTO New_TableName
From Tab1 Inner Join Tabl2
On Tab1.Col1 = Tab2.Col1
----
-----
----
Thanks
Hari
"Gopal" <Gopal@discussions.microsoft.com> wrote in message
news:3DA5E539-D517-41B0-8104-0D270B5A8430@microsoft.com...
> Hello All,
>
> I would like to create a table from a query. The query is a complex one
> with
> results being generated from 9 tables.
> I will do some manipulation on the table and then use it for reporting. I
> cannot use the view here.
>
> Please help.
>
> Regards
> Gopal