create table x as ( )

[sreddy]

CREATE TABLE {table1}
STORAGE clause for table1
AS {sub Query of table2}