两个表的联合查询问题，急等

[phoenix2xp]

两个表，表1有字段：col1、col2、col3，表2有字段：code、value。其中表1中每个字段的值都可以在表2value字段中找到对应值，另外还有几个表一起联合查询

现在我希望查询结果中把表1中col1、col2、col3字段的值都用表2中对应的code代替，请问该如何实现呢？

[phoenix2xp]

可以了！

多谢各位：）

[phoenix2xp]

发现LoveSQL（GG)的才能得到我要的结果，才给了你3分，实在不好意思；）

[yesterday2000]

select b.code from 表1 a,表2 b where a.col1=b.value or a.col2=b.value or a.col3=b.value

[pbsql]

select (select code from t2 where value=t1.col1) code1,
(select code from t2 where value=t1.col2) code2,
(select code from t2 where value=t1.col3) code3
from t1

[victorycyz]

select c1=(select [value] from table2 where code=a.col1),
c2=(select [value] from table2 where code=a.col2),
c3=(select [value] from table2 where code=a.col3)
from table1

[LoveSQL]

select
(select top 1 code from table2 where value=a.col1) as col1,
(select top 1 code from table2 where value=a.col2) as col2,
(select top 1 code from table2 where value=a.col3) as col3
from table1 a