Create a new table from 2 diffrent tables

Hello Newsgroup,
I have two tables(table1, table2) with diffrent fields and I want to create
a new table (newtable) with fields from table1 and table2
Example:
table table1
(
T1field1 char (4),
T1field2 char (4),
)
table table2
(
T2field1 char (4),
T2field2 char (4),
T2field3 char (4),
)
How can I do a query who can give me the result in a new table
like here:
table newtable
(
T1field1 char (4),
T1field2 char (4),
T2field1 char (4),
T2field2 char (4),
T2field3 char (4),
)
Thank you for youre time
WilliWhat are the keys? What do the tow tables have in common? What are the
relationships?
Please either post complete DDL of the tables, or at least include a
description of the relationship(s) between the two tables.
ML
http://milambda.blogspot.com/|||Iam not sure whether i understood your requirement... what iyou are asking
for is simple...
Select * INTO table from table1,table2
This wont make much sense, do u have any connecting feild between these two
tables.
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"Willi Kolmbach" wrote:

> Hello Newsgroup,
> I have two tables(table1, table2) with diffrent fields and I want to creat
e
> a new table (newtable) with fields from table1 and table2
> Example:
> table table1
> (
> T1field1 char (4),
> T1field2 char (4),
> )
> table table2
> (
> T2field1 char (4),
> T2field2 char (4),
> T2field3 char (4),
> )
>
> How can I do a query who can give me the result in a new table
> like here:
> table newtable
> (
> T1field1 char (4),
> T1field2 char (4),
> T2field1 char (4),
> T2field2 char (4),
> T2field3 char (4),
> )
> Thank you for youre time
> Willi
>
>|||Thank you for the fast reply !
Willi
"Sreejith G" <SreejithG@.discussions.microsoft.com> wrote in message
news:61B7DBE9-85E0-4C26-9AEA-24BC01E320E7@.microsoft.com...
> Iam not sure whether i understood your requirement... what iyou are asking
> for is simple...
> Select * INTO table from table1,table2
> This wont make much sense, do u have any connecting feild between these
> two
> tables.
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread and
> time
> asking back if its 2000 or 2005]
>
> "Willi Kolmbach" wrote:
>