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