select t.SQ0000 || ' ' || t.SQSJ00 SQRQ00,
       t.*,
       '' SectionNo,
       '' ItemNo,
       JYLX00 type,
       '' SerialNo,
       '' Prec,
       '' TestTypeNo
  from VW_JY_YW0000_ZYDZBL t, YJ_YW0000 t2
 where t.YJDJH0 = t2.YJDJH0
   and t.brid00 = '3064689'
   and (SQRQ00 >= '20240319' and SQRQ00 <= '20240420')
   and (sfbz00 = '3' or jgzt00 in ('6', '8', '9'))
   and bg0000 is not null
 order by t.BBSDRQ desc