Fork me on GitHub

财务共享初审跟复审是怎么区别的。

 select c.pk_busiact,a.djbh
   from sscdata.er_bxzb a
   left join sscdata.ssc_ssctask b
     on a.pk_jkbx = b.billrelationid
  right join sscdata.ssc_ssctasklog c
     on b.pk_ssctask = c.pk_ssctask
  right join sscdata.md_enumvalue j
     on j.value = a.djzt
    and j.id = 'aed2a08a-03a0-4db7-9ab1-c30e1dc1ca17'
  where a.djbh = '264X20160930033119'

 

posted @ 2016-10-31 14:46  ZZZZW  阅读(1358)  评论(0编辑  收藏  举报
AmazingCounters.com