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