• 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]