一条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'

 

posted @ 2012-12-06 08:35  微明Axel  阅读(176)  评论(0)    收藏  举报