我有一个这样的语句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 * 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/%'