When creating/editing a Virtual Layer using either the
<QGIS> | Layer | Create Layer | New Virtual Layer
or<QGIS> | Layer | Add Layer | Add/Edit Virtual Layer
dialogue, you need to
Import
(orAdd
from source) all referenced layers in the Embedded Layers panel, and use the (editable) names in the SQL; it's a good idea to always""
enclose relation names with characters other thanlowercase_123
, e.g."tAbLe N@m€"
Alternatively, when using the DB Manager, you simply need to connect to the
Virtual Layers
provider in the Providers panel and refer to the layer names as seen in e.g. theProject Layers
tab. Layers created via the DB Manager are automatically considered a Virtual Layer.
Use ST_Intersects
instead of ST_Within
to include freeholds sharing only a portion with the isochrone polygons.