日期:2014-05-16 浏览次数:20743 次
SELECT distinct(A.Jydbh),A.sdzmc,A.dzzmc,A.sxhh,A.jshj,A.hwlxmc,A.Fhrxm,A.Other,A.Jhrq,A.Fgsbm,A.hdfk,B.bencijine,0 as xz
,c.clbh,c.cksj
FROM Jydxx as A left outer join T_B_SKD_MX as B on A.Jydbh = B.jydbh
left join c on c.Jydbh = B.jydbh
where A.del_flag = 0 and ( A.hdfk <>0 ) and (A.yfhxbz=0)
SELECT distinct(A.Jydbh),A.sdzmc,A.dzzmc,A.sxhh,A.jshj,A.hwlxmc,A.Fhrxm,A.Other,
A.Jhrq,A.Fgsbm,A.hdfk,B.bencijine,0 as xz,C.Clbh,C.Cksj
FROM Jydxx as A
left outer join T_B_SKD_MX as B on A.Jydbh = B.jydbh
left outer join fhxx as C on A.Jydbh = C.jydbh
where A.del_flag = 0 and ( A.hdfk <>0 ) and (A.yfhxbz=0)