资料库查询错误,条件是 select main.chinesef, COALESCE( kjv.chap,asv.chap,ncv.chap,unv.chap) as chap,COALESCE( kjv.sec,asv.sec,ncv.sec,unv.sec) as sec,COALESCE( kjv.id,asv.id,ncv.id,unv.id) as rid,main.engs,kjv.txt,asv.txt,gbncv.txt,unv.txt,ispar(main.engs,kjv.chap,kjv.sec),main.id from kjv full join asv on (asv.engs=kjv.engs and asv.chap= kjv.chap and asv.sec=kjv.sec) full join gbncv on (gbncv.engs=kjv.engs and gbncv.chap= kjv.chap and gbncv.sec=kjv.sec) full join unv on (unv.engs=kjv.engs and unv.chap= kjv.chap and unv.sec=kjv.sec) ,main where main.engs=COALESCE( kjv.engs,asv.engs,ncv.engs,unv.engs) and main.chineses='罗' and COALESCE( kjv.chap,asv.chap,ncv.chap,unv.chap)=8 order by main.id asc, chap asc, sec asc !