Re: MySQL query question

[Tom Cooper]

I believe the following will work:
select id,awardname1,b1.awardcode as code1, awardname2, b2.awardcode as code2, awardname3, b3.awardcode from a left join b as b1 on (a.awardname1 = b1.awardname) left join b as b2 on (a.awardname2 = b2.awardname) left join b b3 on (a.awardname3 = b3.awardname) ;