SELECT * FROM Organization WHERE OrgID=#OrgID# select distinct * from organization where OrgID=#OrgID# select distinct * from contacts where OrgID=#OrgID# select * from Organization o, OrgtoProgramtype op, ProgramTypes p where o.orgID=op.orgID and op.ProgramTypeID=p.ProgramTypeID and o.OrgID=#OrgID# select * from Organization o, Geoservices g where o.GeoServiceID=g.GeoServiceID and o.OrgID=#OrgID# select * from Service s, OrgtoService os, Organization o where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Expertise' and o.OrgID=#OrgID# select * from Service s, OrgtoService os, Organization o where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Clients' and o.OrgID=#OrgID# select * from Service s, OrgtoService os, Organization o where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Resources' and o.OrgID=#OrgID# select * from organization where OrgID=#OrgID# Pollution Prevention Agencies and Programs P2RIC logo   Programs Directory

GO BACK

#OrganizationName#
#OrganizationName#

 #profile# Division
#Division#

Expertise
 #Service#, 

Clients
 #Service#, 

Resources
 #Service#, 

Program Type
 #ProgramType#, 

Service Area
 #GeoService#

#Title#
#prefix# #FirstName# #Middle# #lastName#
#Address#
#City#,#State# #zip#
#WorkPhone# x#workExtension#
MOBILE TEL: #MobilePhone#
FAX: #FaxNumber#
#emailName#

 Contact Information
#Division#
#Address1#
#Address2#
#City#, #StateOrProvince# #PostalCode#
#Region# #country#
Timezone: #timezone#
#phone# ext:#extension#
Hotline: #hotline#
FAX: #FaxNumber#
#emailName#