Return to Answer

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

Or, if I wanted all the columns from both tables:

SELECT *
FROM soilmu_a_ny071
FULL OUTER JOIN Component
ON soilmu_a_ny071.MUKEY=Component.mukey;

Based upon the few answers I have gotten, I assume that this would be a View rather than a join. I am looking at this in order to guide the SQL Query.

CREATE VIEW [Soils Extended Data] AS
SELECT *
FROM soilmu_a_ny071
JOIN Component
ON soilmu_a_ny071.MUKEY=Component.mukey;

soilmu_a_ny071 = the shape file imported into PostGIS to create the spatial table and Component = the non-spatial table.

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

Or, if I wanted all the columns from both tables:

SELECT soilmu_a_ny071.*, Component.*
FROM soilmu_a_ny071
FULL OUTER JOIN Component
ON soilmu_a_ny071.MUKEY=Component.mukey
ORDER BY soilmu_a_ny071.FID;

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

Or, if I wanted all the columns from both tables:

SELECT *
FROM soilmu_a_ny071
FULL OUTER JOIN Component
ON soilmu_a_ny071.MUKEY=Component.mukey;

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

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

Or, if I wanted all the columns from both tables:

SELECT soilmu_a_ny071.*, Component.*
FROM soilmu_a_ny071
FULL OUTER JOIN Component
ON soilmu_a_ny071.MUKEY=Component.mukey
ORDER BY soilmu_a_ny071.FID;