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