查不到任何資料，請修改查詢條件再查！ select main.chinesef, COALESCE( unv.chap,bhs.chap) as chap,COALESCE( unv.sec,bhs.sec) as sec,COALESCE( unv.id,bhs.id) as rid,main.engs,unv.txt,bhs.txt,ispar(main.engs,unv.chap,unv.sec),main.id from unv full join bhs on (bhs.engs=unv.engs and bhs.chap= unv.chap and  bhs.sec=unv.sec) ,main where main.engs=COALESCE( unv.engs,bhs.engs) and main.chineses='%ABX' and COALESCE( unv.chap,bhs.chap)=1 order by main.id asc, chap asc, sec asc