adding another tables column to a left join statement

[shefea]

Hi I have the following query that is working just fine..
SELECT S.EMPL,
S.QUALVDTE,
S.CAT,
S.CACTIAT,
S.CACTIATC,
S.CFUNC,
S.CSFUNC


FROM SUDMP.TCRMQAL S

LEFT JOIN SUDMP.TCRMQAL S1 ON S1.EMPL = S.EMPL
GROUP BY S.EMPL, S.QUALVDTE, S.CAT,S.CACTIAT, S.CACTIATC, S.CFUNC, S.CSFUNC
HAVING S.QUALVDTE = MAX(S1.QUALVDTE)
ORDER BY S.EMPL


I need to a description for S.CAT called CATDESC that is stored in another table how do I do this, where should I place it?

Thanks for any help you can offer me.
Best,
shefea