PostGIS: Find Overlap Between Two Polygons

[المشرف العام]

I have a two shapefiles, one is a DMA level and one of US states level.

How do I figure create a shape file containing DMA of a certain state, for instance, Texas from a larger shapefile.

I tried running this query, but with no success

SELECT geom FROM usdma WHERE ST_Overlaps(usdma.geom, usstates.geom) WHERE usstates.name = 'TX';

أكثر...