资料库查询错误,条件是 select main.chinesef, COALESCE( unv.chap,csb.chap,tcv95.chap,recover.chap,nt1864.chap,cbol.chap,cnet.chap,rcuv.chap,ofm.chap,lcc.chap,cumv.chap,pmb.chap,cuwv.chap,cuwve.chap,cwang.chap,orthdox.chap,basset.chap,mormil.chap,wdv.chap,ssewb.chap,marwb.chap,goddwb.chap,hudsonwb.chap,deanwb.chap) as chap,COALESCE( unv.sec,csb.sec,tcv95.sec,recover.sec,nt1864.sec,cbol.sec,cnet.sec,rcuv.sec,ofm.sec,lcc.sec,cumv.sec,pmb.sec,cuwv.sec,cuwve.sec,cwang.sec,orthdox.sec,basset.sec,mormil.sec,wdv.sec,ssewb.sec,marwb.sec,goddwb.sec,hudsonwb.sec,deanwb.sec) as sec,COALESCE( unv.id,csb.id,tcv95.id,recover.id,nt1864.id,cbol.id,cnet.id,rcuv.id,ofm.id,lcc.id,cumv.id,pmb.id,cuwv.id,cuwve.id,cwang.id,orthdox.id,basset.id,mormil.id,wdv.id,ssewb.id,marwb.id,goddwb.id,hudsonwb.id,deanwb.id) as rid,main.engs,unv.txt,gbcsb.txt,tcv95.txt,recover.txt,nt1864.txt,cbol.txt,cnet.txt,rcuv.txt,ofm.txt,lcc.txt,cumv.txt,pmb.txt,cuwv.txt,cuwve.txt,cwang.txt,orthdox.txt,basset.txt,mormil.txt,wdv.txt,ssewb.txt,marwb.txt,goddwb.txt,hudsonwb.txt,deanwb.txt,ispar(main.engs,unv.chap,unv.sec),main.id from unv full join gbcsb on (gbcsb.engs=unv.engs and gbcsb.chap= unv.chap and gbcsb.sec=unv.sec) full join tcv95 on (tcv95.engs=unv.engs and tcv95.chap= unv.chap and tcv95.sec=unv.sec) full join recover on (recover.engs=unv.engs and recover.chap= unv.chap and recover.sec=unv.sec) full join nt1864 on (nt1864.engs=unv.engs and nt1864.chap= unv.chap and nt1864.sec=unv.sec) full join cbol on (cbol.engs=unv.engs and cbol.chap= unv.chap and cbol.sec=unv.sec) full join cnet on (cnet.engs=unv.engs and cnet.chap= unv.chap and cnet.sec=unv.sec) full join rcuv on (rcuv.engs=unv.engs and rcuv.chap= unv.chap and rcuv.sec=unv.sec) full join ofm on (ofm.engs=unv.engs and ofm.chap= unv.chap and ofm.sec=unv.sec) full join lcc on (lcc.engs=unv.engs and lcc.chap= unv.chap and lcc.sec=unv.sec) full join cumv on (cumv.engs=unv.engs and cumv.chap= unv.chap and cumv.sec=unv.sec) full join pmb on (pmb.engs=unv.engs and pmb.chap= unv.chap and pmb.sec=unv.sec) full join cuwv on (cuwv.engs=unv.engs and cuwv.chap= unv.chap and cuwv.sec=unv.sec) full join cuwve on (cuwve.engs=unv.engs and cuwve.chap= unv.chap and cuwve.sec=unv.sec) full join cwang on (cwang.engs=unv.engs and cwang.chap= unv.chap and cwang.sec=unv.sec) full join orthdox on (orthdox.engs=unv.engs and orthdox.chap= unv.chap and orthdox.sec=unv.sec) full join basset on (basset.engs=unv.engs and basset.chap= unv.chap and basset.sec=unv.sec) full join mormil on (mormil.engs=unv.engs and mormil.chap= unv.chap and mormil.sec=unv.sec) full join wdv on (wdv.engs=unv.engs and wdv.chap= unv.chap and wdv.sec=unv.sec) full join ssewb on (ssewb.engs=unv.engs and ssewb.chap= unv.chap and ssewb.sec=unv.sec) full join marwb on (marwb.engs=unv.engs and marwb.chap= unv.chap and marwb.sec=unv.sec) full join goddwb on (goddwb.engs=unv.engs and goddwb.chap= unv.chap and goddwb.sec=unv.sec) full join hudsonwb on (hudsonwb.engs=unv.engs and hudsonwb.chap= unv.chap and hudsonwb.sec=unv.sec) full join deanwb on (deanwb.engs=unv.engs and deanwb.chap= unv.chap and deanwb.sec=unv.sec) ,main where main.engs=COALESCE( unv.engs,csb.engs,tcv95.engs,recover.engs,nt1864.engs,cbol.engs,cnet.engs,rcuv.engs,ofm.engs,lcc.engs,cumv.engs,pmb.engs,cuwv.engs,cuwve.engs,cwang.engs,orthdox.engs,basset.engs,mormil.engs,wdv.engs,ssewb.engs,marwb.engs,goddwb.engs,hudsonwb.engs,deanwb.engs) and main.chineses='林前' and COALESCE( unv.chap,csb.chap,tcv95.chap,recover.chap,nt1864.chap,cbol.chap,cnet.chap,rcuv.chap,ofm.chap,lcc.chap,cumv.chap,pmb.chap,cuwv.chap,cuwve.chap,cwang.chap,orthdox.chap,basset.chap,mormil.chap,wdv.chap,ssewb.chap,marwb.chap,goddwb.chap,hudsonwb.chap,deanwb.chap)=13 order by main.id asc, chap asc, sec asc !