SELECT OrgID, OrgName, OrgContact, OrgConTitle, OrgAddr1, OrgAddr2, OrgCity, OrgState, OrgZip, OrgPhone, OrgFax, OrgEmail, OrgSite
FROM #tblOrgs#
WHERE SiteStatus = 'ACTIVE'
ORDER BY OrgName;
SELECT DISTINCT O.OrgID, O.OrgName, O.OrgContact, O.OrgConTitle, O.OrgAddr1, O.OrgAddr2, O.OrgCity, O.OrgState, O.OrgZip, O.OrgPhone, O.OrgFax, O.OrgEmail, O.OrgSite
FROM #tblOrgs# AS O
INNER JOIN #tblOrgCats# AS C
ON O.OrgID = C.OrgID
WHERE C.AHRS = true
AND SiteStatus = 'ACTIVE'
ORDER BY O.OrgName;
Sustainable Building Resource Directory
The
Sustainable Building Resource Directory website is sponsored by the Virginia Sustainable Building Network, an
organization that brings together representatives from diverse sectors who are
interested in building healthy, environmentally friendly buildings and
sustainable communities. Disclaimer.