Select Service, ServiceID, Type
From Service
Where Type = 'Expertise' and Approved = 0
SELECT OrgID, ServiceID
FROM dOrgToService
WHERE OrgID = #URL.OrgID#
SELECT s.Service, s.ServiceID, s.Type, os.OrgID
FROM dService AS s, dOrgToService AS os
WHERE s.Type='Expertise' and Approved = 1 And s.serviceID = os.ServiceID And orgId= #URL.OrgID#
Select Service, ServiceID, Type
From Service
Where Type = 'Clients' and Approved = 0
SELECT OrgID, ServiceID
FROM dOrgToService
WHERE OrgID = #URL.OrgID#
SELECT s.Service, s.ServiceID, s.Type, os.OrgID
FROM dService AS s, dOrgToService AS os
WHERE s.Type='Clients' and Approved = 1 And s.serviceID = os.ServiceID And orgId= #URL.OrgID#
Select Service, ServiceID, Type
From Service
Where Type = 'Resources' and Approved = 0
SELECT OrgID, ServiceID
FROM dOrgToService
WHERE OrgID = #URL.OrgID#
SELECT s.Service, s.ServiceID, s.Type, os.OrgID
FROM dService AS s, dOrgToService AS os
WHERE s.Type='Resources' and Approved = 1 And s.serviceID = os.ServiceID And orgId= #URL.OrgID#
SELECT OrganizationName
FROM dOrganization
WHERE OrgID = #URL.OrgID#
EDIT A PROGRAM ->
SERVICES -
Step 4
#OrganizationName#
Please select the service(s) which describe your organization.
* At least One