hi ,

i am using my sql with windows nt version. could somebody let me know how to do the following since i am getting error

i want to create a new table with columns from other tables like

create table tab1 select no,name, sal from tab2

but it should not be a temporary table or type =hash (which i think temporary) so tab1 should be permanent. Any way aroung since most rdbms support this feature.

regards. Raj.