除非有这样的语法：
select ... from tb1
where (fa,fb) in (select fc,fd from tb2 ...)
才等同于：
select ... from
(select fc,fd from tb2 ...) tb2
left join tb1 on tb1.fa=tb2.fc and tb1.fb=tb2.fd