I'm very new to sql so I apologize in advance for my very dummy question...
I'm looking for a way to insert into a table A some values stored in another table B only for the features of table A that intersects features of table B.
I tried this:
insert into schema.table_A(columnKJ1) select "columnPO4" from schema.table_B WHERE table_A.geom.STintersects(table_B.geom) = 1
but I get this error message:
cross-database references are not implemented
What is the right way to do that please ?