CREATE TABLE FROM ANOTHER TABLE IN MS SQL SERVER USING QUERY

CREATE TABLE FROM ANOTHER TABLE IN MS SQL SERVER USING QUERY

select * into newtable from oldtable

you will notice the newtable created... you may try out with various combination of joins etc.

The above is valid in ms sql server