Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: query question, possible subquery?

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

Viewing post 1 (of 1 total)