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关联。该怎么写呢???请大哥们帮帮忙啊试了好多方法了呀
调试欢乐多
select * from JCXX_OtherItemRecord where employeeID in (select id from RSGL_Employee)