I figured it out. Guess its useful to try the query designer. This is what I came up with:

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_key

Thanks,

Marcel