in之多字段

 

 

-- in两边元素个数必须相同

-- succss
select * from  tba
where (fa, fb) in 
(
select fa, fb from tbb 
where fc=xxx
order by fd
-- fetch first 1 rows only
);