select ZYID00,
 (BQ_BRTZXX.JLRQ00 || ' ' || substr(BQ_BRTZXX.JLSJ00,0,5) ) JLRQSJ,
 JLRQ00,
 JLSJ00  ,
 to_char(max(DECODE(bq_brtzxx.TZLBID,'3000',TZNR00,null)))  clm0 ,
 to_char(max(DECODE(bq_brtzxx.TZLBID,'3001',TZNR00,null)))  clm1 ,
 to_char(max(DECODE(bq_brtzxx.TZLBID,'3002',TZNR00,null)))  clm2 ,
 to_char(max(DECODE(bq_brtzxx.TZLBID,'3003',TZNR00,null)))  clm3 ,
 to_char(max(DECODE(bq_brtzxx.TZLBID,'3004',TZNR00,null)))  clm4 ,
 to_char(max(DECODE(bq_brtzxx.TZLBID,'3005',TZNR00,null)))  clm5 ,
 to_char(max(DECODE(bq_brtzxx.TZLBID,'3006',TZNR00,null)))  clm6 ,
 to_char(max(DECODE(bq_brtzxx.TZLBID,'3007',TZNR00,null)))  clm7 ,
 --BM_YGBM00.ZWXM00 ZWXM00,
 'black' Color  
 from BQ_BRTZXX   left join BQ_TZLB00 on BQ_TZLB00.TZLBID=BQ_BRTZXX.TZLBID   left join BM_YGBM00 on BM_YGBM00.YGBH00=BQ_BRTZXX.LRR000  
 where hldlb0='3' and zyid00 = 3450692 group by JLRQ00,JLSJ00,ZYID00--,ZWXM00 
 order by JLRQ00,JLSJ00