--
lc.hjmc || '/' || lc.rwmc 表示字段拼接,类似于java字符串中的+
select lc.hjmc,lc.rwmc,jd.jdmc
select lc.hjmc,lc.rwmc,jd.jdmc
from GZWZ_LCJDSJTJ lc,GZWZ_JDMCQXGZ jd where (lc.hjmc || '/' || lc.rwmc) = jd.jdmc
from GZWZ_LCJDSJTJ lc,GZWZ_JDMCQXGZ jd where (lc.hjmc || '/' || lc.rwmc) = jd.jdmc