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 + '_' +...