查不到任何资料，请修改查询条件再查！ select main.chinesef, COALESCE( nstrunv.chap) as chap,COALESCE( nstrunv.sec) as sec,COALESCE( nstrunv.id) as rid,main.engs,nstrunv.txt,ispar(main.engs,nstrunv.chap,nstrunv.sec),main.id from nstrunv,main where main.engs=COALESCE( nstrunv.engs) and main.chineses='%E8%AF%97' and COALESCE( nstrunv.chap)=37 and (COALESCE( nstrunv.sec)>=23 and COALESCE( nstrunv.sec)<=24) order by main.id asc, chap asc, sec asc