Hi
Currently in Denodo Platform INSERT INTO SELECT statements are supported only for populating [Materialized tables](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/materialized_tables/inserting_data_into_materialized_tables/inserting_data_into_materialized_tables) and [Temporary tables](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/temporary_tables/creating_temporary_tables/creating_temporary_tables).
I would either use **Scheduler** or create a [Remote table](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/remote_tables/managing_remote_tables/managing_remote_tables#managing-remote-tables) to insert the data. In case of using Scheduler, I would follow the steps in the Scheduler Administration Tool,
* Create a job with a select statement for instance
> SELECT col1,col2 from base_view2
* Define a new JDBC exporter in the exporter section of the job and use the view where you have to insert the data for instance ‘base_view1’
For more information, you can have a look at the sections [General Structure of a Job](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/general_structure_of_a_job#general-structure-of-a-job) and [Exporters](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/developer_api/extensions_plugins/exporters#exporters) of the Scheduler Administration Guide.
Hope this helps!