SELECT L.CKLXBH,L.CKLXMC,XYLSJE,CYLSJE,ZYLSJE,YXLSJE,XYGJJE, CYGJJE, ZYGJJE, YXGJJE FROM BM_YFCKLX L,VW_YF_CKSRTJ X
WHERE L.CKLXBH=X.TJXMBH(+)
 AND L.CKLXBH<>'08'