ITeye博客

jmStatham的博客

jmStatham · 共 1 篇文章

oracle中distinct关键字导致结果的再一次inner join失败的问题

select a. ,c. from (select jx.jxdxdh, jx.zhdh, jx.zhhm from jxdx_ckzh jx) a inner join (select / distinct / b.jxdxdh,b.fpms from (select gx.jxdxdh, wmsys.wm_concat(hy.hymc || gx.zlbl) fpms from khdx_hy hy, dxgx_hyyjgx_ck gx where hy.khdxdh = gx.khdxdh and 20130421 between gx.qsrq and gx.jsrq and gx…

2014-02-27 15:10 · oracle · 评论(0)