Replace UserID with User Name
I have a SQL query which returns the participant id and I would like to see the Participant name in the last column instead of the id. select Distinct Volumeid "WorkID", MAX(Customer) "Customer", MAX(substr(Conference_Start_Date, 1, 60)) "Conference Start Date",MAX(Conference_Start_Time__EST_) "Conference Start Time",MAX(Conference_Stop_Time__EST_) "Conference End Time", MAX(Location) "Requesting Site",MAX(Additional_Sites) "Additional Sites",MAX(Frequency) "Frequency",MAX(Manager_Approval) "Manager Approval",MAX(decode(seq, 1, Participants, null))||MAX(DECODE(seq, 1, '; ', null))||MAX(decode(seq, 2, Participants, null))||MAX(DECODE(seq, 2, '; ', null))||MAX(decode(seq, 3, Participants, null))||MAX(DECODE(seq, 3, '; ', null))||MAX(decode(seq, 4, Participants, null))||MAX(DECODE(seq, 4, '; ', null))||MAX(decode(seq, 5, Participants, null))||MAX(DECODE(seq, 5, '; ', null)) "Participants" From (select Distinct Volumeid, Customer, Conference_Start_Date, Conference_Start_Time__EST_,Conference_Stop_Time__EST_, Location, Additional_Sites, Frequency, Manager_Approval, Participants, ROW_NUMBER() OVER (PARTITION by Volumeid ORDER BY Volumeid) seqFrom (SELECT A.Volumeid, A.Customer, A.Conference_Start_Time__EST_, A.Conference_Start_Date, A.Conference_Stop_Time__EST_,A.Location, A.Additional_Sites, A.Frequency, A.Manager_Approval, A.Participants FROM BK_Vits_Request A, kuaf C where A.Participants=C.id )) Group by Volumeid
