Apologies if the title is a bit confusing what I have are two tables. One table hold the FIPS (county code for USA) followed by the list of geoids or tract_numbers that fall into that associated FIPS or County. Here is what the table looks like
I have a second table that holds each geoid or tract_number with their associated geojson object that is in the geometry column. The table looks like this
What I need to do is build a query that will grab each geojson object for each associated FIPS/county code. I hope this makes sense.
I am not exactly sure if this is the most efficient in terms the way the data is stored so I am up for having that discussion. Otherwise, I am a bit lost as to how to build this query. Any help is greatly appreciated.