如果 B中jsx 只要在表A中的dyxt 和hcxt 有相等的,不一定A中的一行。jsx=dyxt=hcxt
select b.id,b.jsx from b where b.jsx in(select dyxt from a) and b.jsx in (select hcxt from a)
如果要是一行
select b.id,a.dyxt,a.hcxt from a inner join b on a.dyxt=b.jsx and a.hcxt=b.jsx
select B.ID,A.dyxt,A.hcxt from A,B where A.id = B.id and A.dyxt= B.JSX and A.hcxt = B.JSX