各位大侠帮忙看一下,怎么解决
select oprno from workflow where task='0' and oppno='12121212'
结果是(123,234) 两个值
然后 select * from operator where id in(123,234) 可以查询出来
但是我要是执行select * from operator where id in(select oprno from workflow where task='0' and oppno='12121212') 就说是无效字符
select oprno from workflow where task='0' and oppno='12121212'
结果是(123,234) 两个值
然后 select * from operator where id in(123,234) 可以查询出来
但是我要是执行select * from operator where id in(select oprno from workflow where task='0' and oppno='12121212') 就说是无效字符
select * from operator where id in (select oprno from workflow where task='0' and oppno='12121212')
http://blog.csdn.net/laodao1/article/details/8115193