Topic: QGIS update table column with join to another table
I thought I had figured out how to do this, but if I have, I've forgotten.
This is what I would call a classic operation for LERC GIS people. I have a set of point records and a set of polygon records. I want to update a field in the point records with information from the polygon records, depending on which polygon each point record falls in geographically. Put another way, I want to label each point record with the name of the polygon that contains it.
I think typically LERC people might do this kind of thing to label a set of species records with the name of local wildlife sites they were recorded in, or something like that.
In MapInfo, you would use "update column" where you would be able to choose other tables that you currently have open. You would then define the join between the two tables. In this example, by saying "where object from table one is within object from table two". It's very straight forward.
It might be straight forward in QGIS, but I can't work it out. I can't seem to Google the correct question to find relevant help either. There is an expression builder in order to update columns, but I can't see how to include fields from other tables.
Any help would be greatly appreciated.