I am new to geodatabase queries and cartodb. I am trying to write a SELECT query that will do the following.
I have two tables.
Table 1 contains congressional district polygons and info about representatives.
Table 2 contains service territory polygons and info about providers.
There is no common key between the tables.
For each polygon in Table 1, I need to find all of the intersecting polygons from Table 2, and return all of the calculated polygon intersections.