I believe you need to [insert](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/inserts_updates_and_deletes_over_views/insert_statement/insert_statement#insert-statement) values of a specific column into the target view from the source view. In order to do this, you can use the following syntax where ViewA is the target view, ViewB is the source view and Field1 is the field:
> INSERT INTO ViewB SELECT Field1 FROM ViewA
In this scenario, you should provide the required** field name only in the Select statement**.
Make note that the provided** field name should match the field in the Target view**. If not, you could use the alias name in the select statement as below:
> INSERT INTO ViewB SELECT Field2 as Field1 FROM ViewA
Hope this helps!