I am having two tables, table1 and table2.
I want to know which parts of table2 intersect with table1. Having that information, I want to write the attributes from table2 into table1 (where they intersect) and create a completely new table3 of it. I want to preserve the geometry (polygons) from table1
CREATE TABLE table3 AS
SELECT t1.*, t2.c, t2.d FROM table1 t1
JOIN table2 t2
ON ST_Intersects(t1.geom, t1.geom);
Would that give me my desired result?

No comments:
Post a Comment