联查sql，要加上table1.id=table2.id，否则可能会出现重复值，去掉联查sql重复值

有一条语句，联合查询的，表中的XH字段是唯一的，可是却查出来了3条一样的数据，后来同事帮忙看了下，才发现，原来是忘记加table1.id=table2.id了

SELECT hmd.xh as xh,hmd.lrdw as lrdw,hmd.czy as czy,hmd.larq as larq,hmd.yxq as yxq,hmd.wfxz as wfxz,hmd.hpzl as hpzl,hmd.hphm as hphm,hmd.bz as bz,hmd.fdjh as fdjh,hmd.clpp as clpp,hmd.cjh as cjh,hmd.jdcsyr as jdcsyr,hmd.cllx as cllx,hmd.csys as csys,hmd.tjbz as tjbz,hmd.fz as fz,hmd.ip as ip,hmd.bm as bm FROM kk.kkhmd hmd,kk.kkyh yh,kk.kkbmqx bmqx WHERE yh.id = 'heisetoufa'  and hmd.yxq = to_date('2008-04-20','YYYY-MM-DD HH24:MI:SS') and hmd.wfxz = '234234' and hmd.hpzl = '03' and hmd.hphm = '234234' and hmd.bz = 'D' and hmd.fdjh = '23423' and hmd.clpp = '23424' and hmd.cjh = '23423' and hmd.jdcsyr = '234234' and hmd.cllx = 'J11' and hmd.csys = 'CC' and hmd.tjbz = '234234' and hmd.lrdw = '北京市ZL发展公司' and bmqx.bm in ('研发部') and yh.id=bmqx.id

 

 

 

重点就是 yh.id=bmqx.id

 

黑色头发  http://heisetoufa.iteye.com

如果发现本文有误，欢迎批评指正