I know you can create a table as select * from another table. But can you create a table as select * from a view_name?
create table AAA as select * from BBBB;
BBB is a view not a table.
+ Reply to Thread
Results 1 to 2 of 2
Thread: Create a table off a view
Click Here to Expand Forum to Full Width