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.
I’ve used 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.