I have a .gml file of every freehold title in a city outlined red below. I want to create a virtual layer of the freeholds which are contained within the blue-green isochrones. Even if a small portion of the freehold title intersects the isochrone, I need the entire freehold to be displayed.
my code so far:
SELECT * FROM Freeholds, Isochrones WHERE st_within(Freeholds.geometry, Isochrones.geometry) = 1
I am a novice at SQL and recieve the error 'Referenced table Freeholds in query not found!' How can I correct the query?