一对一对多关系 勿忘

select t.creatortime,
       t.title,
       gw.fwj_bh_mc || '[' || gw.fwj_bh_year || ']' || gw.fwj_bh_no as bh,
       '' as fs,
       (select h.username
          from wf_history_course h
         where h.rowguid = t.rowguid
           and h.workitemid = (select w.workitemid
                                 from wf_workitem w
                                where w.flowinstanceid = t.flowinstanceid
                                  and w.actdefid = 'ngrng'
                                  and rownum = 1)) cbr,
       (select h.deptname
          from wf_history_course h
         where h.rowguid = t.rowguid
           and h.workitemid = (select w.workitemid
                                 from wf_workitem w
                                where w.flowinstanceid = t.flowinstanceid
                                  and w.actdefid = 'ngrng'
                                  and rownum = 1)) cbcs,
       (select h.username
          from wf_history_course h
         where h.rowguid = t.rowguid
           and h.workitemid = (select w.workitemid
                                 from wf_workitem w
                                where w.flowinstanceid = t.flowinstanceid
                                  and w.actdefid = 'ldps'
                                  and rownum = 1)) LDPS
  from wf_workflowinstance t, Gw_t_Gwlzb gw
 where t.rowguid = gw.sljdid
   and t.flowdefid = 'gwlz:fwlc'
     
   and (select count(*)
          from wf_workitem w
         where w.flowinstanceid = t.flowinstanceid
           and w.actdefid = 'yz') > 0