Hi Anyone know how to perform a create table like it is done in oracle

Create table xyz as
(select * from A,B where a.id=b.id)

select *
into xyz
from A,B
where a.id=b.id

[quoted text, click to view]

Example:

--This will create a new table called MyTable and copy all the records
froms Authors table.
SELECT * INTO MyTable FROM Authors

--This will create a new table called YourTable without copying any
records from Authors table
SELECT * INTO YourTable FROM Authors
WHERE 4=5

Rohtash Kapoor
http://www.sqlmantra.com



[quoted text, click to view]

Hi,

use the below syntax.

select * into table_name from table_a,table_b where ........

--
Thanks
Hari
MCDBA
[quoted text, click to view]