select A.REPORT_ID JYYWID,A.REPORT_TIME cbgrq0,
                    A.CHECK_NAME shr000,A.CREATE_NAME jyr000
                    from VLIS_REPORT_MASTER A where A.MZZYBZ = '2' and REPORT_ID='189202503192'


  select B.REPORT_ID JYYWID,B.ITEM_CODE BZBM00,
         B.ITEM_NAME ZWMC00,B.ITEM_VALUE JYJG00,
         B.VALUE_UNIT JGDW00,B.VALUE_TIP JGZCBZ,
         case when (B.VALUE_MIN is null and B.VALUE_MAX is not null) then B.VALUE_MAX
              when (B.VALUE_MIN is not null and B.VALUE_MAX is null) then B.VALUE_MIN
              when (B.VALUE_MIN is not null and B.VALUE_MAX is not null) then B.VALUE_MIN+'-'+B.VALUE_MAX
              else '' end CKFW00
   from VLIS_REPORT_DETAIL B 
   where REPORT_ID='189202503192' order by B.SORT_CODE