You've added aliases Jobs->t1 and JobDescriptions->t2 so in SELECT SQL see tables Jobs, JobDescriptions as t1, t2.
Try:
SELECT t1.JobFamily, t2.[description]
FROM Jobs t1
INNER JOIN JobDescriptions t2 ON
t2.ParentRole = t1.JobFamily + '_' + t1.[description]