一条SQL语句-OA

select t.*,t1.*,t2.* ,t3.*
  from work_weekly_task_master t, work_task t1 , work_weekly_task_detail t2 ,WORK_MAINTAIN_TASK t3
 where t.work_task = t1.work_task_id and t2.weekly_task_master = t.weekly_task_master_id and t3.maintain_task_id = t1.work_maintain_task
   and t1.work_type = '04'

 

转载于:https://www.cnblogs.com/geniussoft/archive/2012/12/06/2804343.html