Select * From OutsideUsers where orgid= #URL.OrgID# select * from dorganization where OrgID=#URL.OrgID# select s.* from dService s, dOrgtoService os, dOrganization o where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Expertise' and o.OrgID=#URL.OrgID# select * from dService s, dOrgtoService os, dOrganization o where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Clients' and o.OrgID=#URL.OrgID# select * from dService s, dOrgtoService os, dOrganization o where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Resources' and o.OrgID=#URL.OrgID# select * from dProgramTypes s, dOrgtoProgramType os, dOrganization o where o.orgID=os.orgID and os.ProgramTypeID=s.ProgramTypeID and o.OrgID=#URL.OrgID# #GetUserEmail.fname# #GetUserEmail.lname# This e-mail is automatically generated to let you know that the information for your organization has been changed in our database. We might contact you to validate the information. Once the information has been validated, the status for the organization will be changed and will be displayed on our site. Current Information: ==================== Organization Name: #getORG.OrganizationName# Profile: #getOrg.Profile# Division: #getOrg.Division# Address: #getOrg.Address1# #getOrg.Address1# #getOrg.City# #getOrg.StateOrProvince# #getOrg.PostalCode# #getOrg.Country# Region: #getOrg.Region# TimeZone: #getOrg.TimeZone# Phone Number: #getOrg.Phone# Extension: #getOrg.Extension# Fax Number: #getOrg.FaxNumber# Email Address: #getOrg.EmailName# HotLine: #getOrg.Hotline# URL: #getOrg.URL# Graphic URL: #getOrg.GraphicURL# Resources: #qryResourceList# Expertise: #qryExpertiseList# Clients: #qryClientList# ProgramType: #qryProgramsList#