我有一个这样的语句select * from wspriv_adminlog tt where tt.worker_id in(select t1.worker_id from wspriv_worker t1 where t1.deptid in(select t2.deptid from wspriv_dept t2 where t2.path like '/9/58/%')) ;
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/27 12:25:43
![我有一个这样的语句select * from wspriv_adminlog tt where tt.worker_id in(select t1.worker_id from wspriv_worker t1 where t1.deptid in(select t2.deptid from wspriv_dept t2 where t2.path like '/9/58/%')) ;](/uploads/image/z/14232351-39-1.jpg?t=%E6%88%91%E6%9C%89%E4%B8%80%E4%B8%AA%E8%BF%99%E6%A0%B7%E7%9A%84%E8%AF%AD%E5%8F%A5select+%2A+from+wspriv_adminlog+tt+where+tt.worker_id+in%28select+t1.worker_id+from+wspriv_worker+t1+where+t1.deptid+in%28select+t2.deptid+from+wspriv_dept+t2+where+t2.path+like+%27%2F9%2F58%2F%25%27%29%29+%3B)
我有一个这样的语句select * from wspriv_adminlog tt where tt.worker_id in(select t1.worker_id from wspriv_worker t1 where t1.deptid in(select t2.deptid from wspriv_dept t2 where t2.path like '/9/58/%')) ;
我有一个这样的语句
select * from wspriv_adminlog tt where tt.worker_id in
(select t1.worker_id from wspriv_worker t1 where t1.deptid in
(select t2.deptid from wspriv_dept t2 where t2.path like '/9/58/%')) ;
我有一个这样的语句select * from wspriv_adminlog tt where tt.worker_id in(select t1.worker_id from wspriv_worker t1 where t1.deptid in(select t2.deptid from wspriv_dept t2 where t2.path like '/9/58/%')) ;
select t1.* (这是t1的所有字段) from wspriv_adminlog tt ,wspriv_worker t1 ,wspriv_dept t2
where tt.worker_id =t1.worker_id and t1.deptid in=t2.deptid and t2.path like '/9/58/%'