Based upon the few answers I have gotten, I assume that this would be a Full Join. I am looking at this in order to guide the SQL Query.
SELECT soilmu_a_ny071.MUSYM, Component.hydricrating
FROM soilmu_a_ny071
FULL OUTER JOIN Component
ON soilmu_a_ny071.MUKEY=Component.mukey
ORDER BY soilmu_a_ny071.MUKEY;
soilmu_a_ny071 = the shape file imported into PostGIS to create the spatial table and Component = the non-spatial table