查不到任何資料，請修改查詢條件再查！ select main.chinesef, COALESCE( unv.chap,kjv.chap) as chap,COALESCE( unv.sec,kjv.sec) as sec,COALESCE( unv.id,kjv.id) as rid,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='%E5%8F%AF' and COALESCE( unv.chap,kjv.chap)=11 and COALESCE( unv.sec,kjv.sec)=24 order by main.id asc, chap asc, sec asc