SELECT Cteam.team_key, Cemployeelookup.elu_eid, Clookup.lup_value; FROM ; cTEAM Cteam ; INNER JOIN CEMPLOYEELOOKUP Cemployeelookup ; INNER JOIN CLOOKUP Clookup ; ON Clookup.lup_id = Cemployeelookup.elu_type ; ON Cteam.elu_id = Cemployeelookup.elu_keyThanks,