Simple question. Queries for multiple category names

stephensun

Two tables T_resume_language, T_language_sort
The first table has three fields. The second table is the category table.
Now I want to find out if the name of the category must be written three times like this.
Is there any good way. This doesn't look very good.
select languageId1, languageId2, languageId3
, (select a.cname from T_language_sort as a, T_resume_language as b where a.code = b. languageId1 and b. [resumeid] = @ id) as language1,
(select a.cname from T_language_sort as a, T_resume_language as b where a.code = b. languageId2 and b. [resumeid] = @ id) as language2,
(select a.cname from T_language_sort as a, T_resume_language as b where a.code = b. languageId3 and b. [resumeid] = @ id) as language3
from T_resume_language as a where [resumeid] = @ id

zy_1306

select a.languageId1, a.languageId2, a.languageId3, b.cname, c.cname, d.cname
from T_resume_language a
left join T_language_sort b on a.languageId1 = b.code
left join T_language_sort c on a.languageId2 = c.code
left join T_language_sort d on a.languageId3 = d.code
where a. [resumeid] = @id

michealhenry

select languageId1, languageId2, languageId3,
b.cname as language1, c.cname as language2, d.cname as language3
from T_resume_language as a inner join T_language_sort as b on b.code = a. languageId1
                            inner join T_language_sort as c on c.code = a. languageId2
                            inner join T_language_sort as d on d.code = a. languageId3
where [resumeid] = @ id

stephensun

I understand everyone's meaning, that is to say, there is no other good way to only inline a few times.