I have a queston for method #2.
I've been told TUNING rule: avoid multi-table join... keep table join to be 2 maximum.
if you want display all "description" for a employy how many table joins?
does it really hurt the performance?