select C.XM0000,C.MRN000,C.XB0000,SUBSTR(SF_XT_CSRQTONL(C.CSRQ00,B.SQRQ00),1,8) as BRNL00,
B.KSMC00,B.BQMC00,B.CH0000,B.LCZDMC,a.CKRQ00,a.CKSJ00,a.XYPZMC,a.XDBH00,a.CKSL00,a.CKDW00,
c.CHYS00, c.SCS000,DECODE(SFJWSX,'1','ÓÐ','ÎÞ') SFJWSX,ZDXX00||'    RHѪÐÍ:'||c.RHXX00 ZDXX00,
decode(b.SQDFZH,NULL,b.SQDH00,b.SQDFZH) SQDFZH, decode(b.SQDFZH,NULL,b.SQDH00,b.SQDFZH) SQDFZ1
 from XK_XYCK00 a,XK_SXSQ00 b,XK_BRXX00 c where  a.SQDH00=b.SQDH00 and b.BRID00=c.BRID00
 and (a.SQDH00= '007684') order by a.SQDH00