I am self taught in GIS, so I apologize ahead of time for my noobness.
In ArcGIS you have two options to associate data in a table to spatial data. Based upon my understanding, the first is Join which allows the join of 1:1 or many:1. Then there is Relate which allows 1:many.
I downloaded soils data from Web Soils Survey. In this data there is a spatial data, a shape file named soilmu_a_ny071.shp. And there is tabular data named component in soildb_US_2003.mdb.
I need to relate the spatial data to many attributes in the tabular data based upon the common field MUKEY. Is there a way to Relate in QGIS 2.0? I also have Postgresql and PostGIS installed, so is there a way to do it through there?