In order to create a table from a view that you have already created, all u need is to execute the following query:

select * INTO <Table Name> from <View Name>
Advertisements