子查询返回的值不止一个.如何解决呢？在线等待啊。。急！！！

[kissapple500]

select * from JCXX_OtherItemRecord where employeeID=(select id from RSGL_Employee)

我要查找JCXX_OtherItemRecord表中的employeeID只要等于(select id from RSGL_Employee) 这个结果集里的ID的所有集合。JCXX_OtherItemRecord表中employeeID跟RSGL_Employee表的ID关联。

该怎么写呢？？？请大哥们帮帮忙啊。。。试了好多方法了呀。。。

[hao1hao2hao3]

select * from JCXX_OtherItemRecord where employeeID in (select id from RSGL_Employee)  

[情殇无限]

select * from JCXX_OtherItemRecord where employeeID in (select id from RSGL_Employee)  

[feixiaocaohen]

select * from JCXX_OtherItemRecord where employeeID in (select id from RSGL_Employee)

[hao1hao2hao3]

或者

select * from JCXX_OtherItemRecord  as a join RSGL_Employee as b  on a.employeeid = b.id where ....

[kissapple500]

啊。谢谢大家了。。原来就是IN啊。。哈哈。。

[feilniu]

select * from JCXX_OtherItemRecord where employeeID=any(select id from RSGL_Employee)

这样也行。不过没有IN常用。