小弟菜鸟,求SQL 信息表中有几个字段
status1,status2,status3
字典表中主要有
kind,code,name两表关系是信息表的每个status与字典表的code对应。字典表的kind区分是哪个status。需要查询出每个status对应的字典表中的namestatus1,status2,status3,status4
"1" ,"2", ,"1" ,"1"kind, code, name
"column1","1", "状态1"
"column1","2", "状态2""column2","1", "状态A"
"column2","2", "状态B""column3","1", "状态a"
"column3","2", "状态b"kind的值是一定的,column1就对应status1请高手赐教。
status1,status2,status3
字典表中主要有
kind,code,name两表关系是信息表的每个status与字典表的code对应。字典表的kind区分是哪个status。需要查询出每个status对应的字典表中的namestatus1,status2,status3,status4
"1" ,"2", ,"1" ,"1"kind, code, name
"column1","1", "状态1"
"column1","2", "状态2""column2","1", "状态A"
"column2","2", "状态B""column3","1", "状态a"
"column3","2", "状态b"kind的值是一定的,column1就对应status1请高手赐教。
没有环境,你测试下--info 信息表
--dic 字典表select
(select name from dic where kind ='column1' where code=info.status1) name1,
(select name from dic where kind ='column2' where code=info.status2) name2,
(select name from dic where kind ='column3' where code=info.status3) name3
from info
select
(select name from dic where kind ='column1' and code=info.status1) name1,
(select name from dic where kind ='column2' and code=info.status2) name2,
(select name from dic where kind ='column3' and code=info.status3) name3
from info
谢谢了。