[SuperZen]

select t1.user, t3.prof
from t1
left join t2 on t1.id = t2.t1_id
left join t3 on t2.t3_id = t3.id