SELECT DISTINCT res.resource_name name, sr.salesrep_id resource_id , sr.org_id from jtf_rs_salesreps sr, jtf_rs_resource_extns_vl res WHERE res.resource_id = sr.resource_id
View Text - HTML Formatted
SELECT DISTINCT RES.RESOURCE_NAME NAME , SR.SALESREP_ID RESOURCE_ID , SR.ORG_ID FROM JTF_RS_SALESREPS SR , JTF_RS_RESOURCE_EXTNS_VL RES WHERE RES.RESOURCE_ID = SR.RESOURCE_ID