-- 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
);
-- 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
);