I have two vector layers (shapefile) with the same columns and layout in each. One comes from the county and is frequently updated, and the other is manual additions I've made. I'm looking for a way to get a virtual combined layer for all the parcels from both layers.
It looks like QGIS virtual layer would work but I'm not sure how to use the query box. (very new to sqlite)
So far I have both layers imported into 'embedded layers' and I can get the data from one with:
select geometry as geometry, pin as pin from parcel_address
the other layer is named parcel_manual.
How do I get the data from both?