I have the following shapefiles:

* **county.shp**: polygons referring to country land subdivisions
* **lake.shp**: polygons referring to lakes, ponds, etc.

Layers attributes are as follow:

* **county.shp**

	+ id INTEGER
	+ name TEXT
	+ code INTEGER
* **lake.shp**

	+ id INTEGER
	+ code INTEGER

The `code`attribute is not filled for `lake.shp`layer. I would like to update this field by intersecting both layers and bring back `code`values from `county.shp` to `lake.shp`.

I know I can do this with the *Join Attributes by Location* tool, but this produces a new shapefile with columns put together. Is it possible to do a simply update `lake.shp` layer based on a spatial intersection?