sql: 多字段的in_习惯累积沉淀_新浪博客

select * from xs_xshd hd where hd.id_kh,hd.id_xm in (select hd2.id_kh,hd2.id_xm from xs_xshd hd2 where hd2.id ='00150118170726656001')

多字段的in 不是这样

 

是这样

select *
  from xs_xshd hd
 where (hd.id_kh, hd.id_xm) in
       (select hd2.id_kh, hd2.id_xm
          from xs_xshd hd2
         where hd2.id = '00150119094301562004')

 

 

加上括号