Hi, I'm back after quite a long absence, and mostly enjoying using 9.
The Update with join syntax is a little different to what I am used to. Looking at other forum posts I have come up with the following:
SELECT a.[mfd_id], a.[Geom], b.[Acquired Type]
FROM [Gross Surplus Land Filtered] as a
INNER JOIN [Gross Surplus Land] as b
ON GeomContains(b.[Geom], a.[Geom], 0)
SET a.[Acquired Type] = b.[Acquired Type]
My schema is
[Acquired Type] varchar
for both source and destination tables.
The select query runs fine, and is the output I want to get, but when running the update I get Cannot parse query.
I've read some threads copying across indexes and so on, but I would expect a different error message if that were the case.
Could this be clarified a bit more in the manual, given every database implements it slightly differently and I don't think it's in any SQL standard?