大家帮我看看这条SQL语句该如何去写！

[einsteincao]

有这样两个表：表a 和表b a中有以下两个字段school_code、department_code，而表b中有code、name两个字段，用于把所有的code解释为name。 希望只用一次查询就能把code对应的name查出来该如何写这条sql语句呢？

[pengdali]

select (select name from 表b where code=表a.school_code),(select name from 表b where code=表a.department_code) from 表a

[wengdy2000]

select school_code ,'school_name'= (select name from b where b.code=a.school_code),department_code,'department_code'=(select name from b where b.code=a.department_code)
from a

[einsteincao]

to：大力！ 这样做效率是不是会非常低？

[bhw0871]

用视图试试!用name直接填充code!

[einsteincao]

I have solute this question! code here:

select b1.name,b2.name
from a
inner join b as b1 on a.school_code = b1.code
inner join b as b2 on a.department_code = b2.code