SELECT manager_id, organization_id, organization_name FROM pa_rep_res_orgs_v UNION SELECT 0,0, meaning FROM pa_lookups WHERE lookup_type = 'PA_REP_ALL'
View Text - HTML Formatted
SELECT MANAGER_ID , ORGANIZATION_ID , ORGANIZATION_NAME FROM PA_REP_RES_ORGS_V UNION SELECT 0 , 0 , MEANING FROM PA_LOOKUPS WHERE LOOKUP_TYPE = 'PA_REP_ALL'