Create table from a result of query

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Create table from a result of query

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-11-13 : 08:01:11

Manish Batra writes "Hi,
I want to creating a table that get all the colymns and data from a reult of a query that uses around 2 left outer join. I tried it as

create table man
as
select col1 as one, col2 as two from table1 c1 left join table2 c2 on [condition] left join table3 c3 on [condition]

but did get a syntax error.

pls help

thanx
with regards
manish"

drymchaser
Aged Yak Warrior

552 Posts

Posted - 2003-11-13 : 09:00:03

Do CREATE TABLE... (preferred method)
Then do INSERT...SELECT

OR

SELECT...
INTO man
FROM ....

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources