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: UPDATE ( 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 mfd_id int64 Geom geom [Acquired Type] varchar mfd_id_x btree Shape_x rtree 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?
|