select a.*,
       b.ZYHGHH,
       b.BRXM00,
       b.ZLXMJC,
       b.ZYGHID,
       b.XB0000,
       b.NL0000,
       b.CH0000,
       (select decode(JGZT00,
                      '0',
                      '申请',
                      '1',
                      '采集',
                      '2',
                      '签收',
                      '3',
                      '退回',
                      '4',
                      '排样',
                      '5',
                      '对应',
                      '6',
                      '确认',
                      '7',
                      '删除',
                      '8',
                      '打印')
          from jy_yw0000
         where yjdjh0 = b.yjdjh0) JGZT00,
       (select BBMC00 from BM_BBZD00 where BBID00 = b.BBID00) BBMC00
  from JY_BBTHJL a, YJ_YW0000 b
 where a.YJDJH0 = b.YJDJH0
   and b.MZZYBZ = '1'
   and b.KDBQ00 = '29'
   and a.THRQ00 >= '20190701'
   and a.THRQ00 <= '20190802'