Table 1 has a relationship to table 2 on [workRelationship] and [jobRelationship] on Table1.id
I'd like to form a select query that would return:
Table2[id] , [workRelationship].description, [jobRelationship].description
OR in laymans terms using data above:
342, Average, Poor
452, Poor, Good
with [workRelationship] producing the description from Table1 and not a number.Any Help would be much appreciated.
I have used an inner join but because there are two columns(workRelationship, jobRelationship) I only get one result.
Last edited by grooverinthesouth; 09-27-06 at 09:34.
, wrkRel.description as wrkRel_descr
, jobRel.description as jobRel_descr
join Table1 as wrkRel
on wrkRel.id = Table2.workRelationship
join Table1 as jobRel
on jobRel.id = Table2.jobRelationship