select t.*,''SectionNo,''ItemNo ,decode((select count(1) from BM_JYZYZB a where t.zyzbid=a.zyzbid and a.zyzbmc like'%ϸ¾ú%'), 1,
 '2', '1') type,''SerialNo,''Prec,''TestTypeNo  from VW_JY_YW0000_ZYDZBL t where t.zyhghh= '1600377' and (sfbz00='3' or 
jgzt00>6) order by  t.BBSDRQ desc
ÔÚÂð