SQL Inner join

    SELECT
    sh.*,
    sheltertype.TypeID
    FROM
    (
    SELECT ShelterName,
         ShelterAddress,
         City,
         STATE,
         ZipCode,
         ShelterPhone,
         ShelterWebsite,
         ShelterType
    FROM zipcode
    INNER JOIN shelter ON zipcode.ZipCode = shelter.ShelterZip
    ) AS sh
    INNER JOIN sheltertype on sheltertype.TypeID = sh.ShelterType;