I have several polygon layers that I would like to merge and dissolve within a virtual layer in QGIS. So that any changes made to the individual layers will automatically update in the merged/dissolved Virtual Layer. I want to dissolve the entire layers, not based on any fields.
ST_Union to do this with a single layer, as below:
SELECT ST_Union(geometry) FROM "Important Wetlands"
What is the correct syntax to add multiple layers to this Virtual Layer?
The layers are in a GeoPackage.