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
SELECT CSID FROM #tblCases# WHERE OrgID = #qryAllOrgs.OrgID#;
Sustainable Building Resource Directory
[Organization Search] - [View Full Directory] - [View By Category] - [Product Categories]
[Case Studies] [Green and Affordable Housing Resources]
Full DirectoryGreen and Affordable Housing Resources
#qryAllOrgs.OrgName# #qryAllOrgs.OrgSite# Case Study ADMIN: [Add Case Study]
  #qryAllOrgs.OrgAddr1#
#qryAllOrgs.OrgAddr2#
 #qryAllOrgs.OrgCity#, #qryAllOrgs.OrgState# #qryAllOrgs.OrgZip#
TEL: #qryAllOrgs.OrgPhone#
FAX: #qryAllOrgs.OrgFax# 		#qryAllOrgs.OrgContact#
#qryAllOrgs.OrgConTitle#
 #qryAllOrgs.OrgEmail#
ADMIN: [Edit Details] - [DELETE #qryAllOrgs.OrgName#]
No Organizations were found in the database.
 
 

Virginia Sustainable Building Network 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.

Copyright © 2005 Virginia Sustainable Building Network.