select XM0000,GHID00,GHH000,GHKS00,(select YBSBK0 from VW_SF_BRZHXX where BRID00=a.BRID00 and rownum=1) as YBSBK0,a.GHKSMC,a.GHYXM0,a.GHRQ00,a.GHSJ00,a.GHLBMC from VW_SF_BRGHXX a where BRID00=17990675 and GHLB00<>-99999 and GHKS00 = 2193 and THBZ00 <> '0' and GHRQ00 >= '20201030' and GHRQ00 <= '20201030' and a.GHKS00 in ( 2241 )