In general, when using the** 'Create from Query**' option, the SQL query may have interpolation variables that allow the SQL query sent to the database to be parameterized according to the specified query conditions. You could refer to the section [Creating Base Views from SQL Queries](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#creating-base-views-from-sql-queries) of the Virtual DataPort Administration Guide for more information.
Regarding creating a dynamic Union view, I would follow the steps mentioned below:
* Create a self-referential JDBC data source for the VDP server.
* Now, use the 'Create from query' option to create a base view using the **SELECT UNION** statements in the query with an interpolation parameter.
For your information, you can have a look at the section [UNION Clause](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/queries_select_statement/union_clause/union_clause#union-clause) of the Virtual DataPort VQL Guide.
If you need further assistance and if you are a valid support user, you could create a support case in [Denodo Support Site](https://support.denodo.com/) so that our support team will assist you.
Hope this helps!