查不到任何資料,請修改查詢條件再查! select main.chinesef, COALESCE( unv.chap,kjv.chap) as chap,COALESCE( unv.sec,kjv.sec) as sec,COALESCE( unv.id,kjv.id) as id,main.engs,unv.txt,kjv.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) ,main where main.engs=COALESCE( unv.engs,kjv.engs) and main.chineses='���' and COALESCE( unv.chap,kjv.chap)=1 and COALESCE( unv.sec,kjv.sec)=15 order by unv.id