查不到任何资料,请修改查询条件再查! select main.chinesef, COALESCE( afhuang.chap) as chap,COALESCE( afhuang.sec) as sec,COALESCE( afhuang.id) as rid,main.engs,afhuang.txt,ispar(main.engs,afhuang.chap,afhuang.sec),main.id from afhuang,main where main.engs=COALESCE( afhuang.engs) and main.chineses='赛' and COALESCE( afhuang.chap)=66 and COALESCE( afhuang.sec)=1 order by main.id asc, chap asc, sec asc