select ( select dept.id from dept where dept.name=test.name ) ids , x.name from ( select test.id , test.name from test left test1 on test.id=test1.id ) x
这句sql 主要的 问的 select dept.id from dept where dept.name=test.name
test.name 为什么在DB2中
识别不出来呢 如何 改造 能让其 识别
求高手帮忙 小弟 在此 多谢了
------解决方案--------------------------------------------------------
- SQL code
select ( select dept.id from dept where dept.name = x.name ) ids , x.name from ( select test.id , test.name from test left test1 on test.id = test1.id ) x