mysql - 多列 IN 子句

Question

有没有办法只使用一个使用多列 IN 子句的查询来实现以下联合查询？

而不是使用

select * 
from table_a 
where field_a in (select field_1 from table_b) 
union
select * 
from table_a 
where field_a in (select field_2 from table_b);

我想创建如下所示的内容:

select * 
from table_a 
where field_a in (select field_1,field_2 from table_b) ;

Answer 1

最多只能将联合放在子查询中:

select * 
from table_a 
where field_a in (select field_1 from table_b union select field_2 from table_b)

或者:

select * 
from table_a 
where field_a in (select field_1 from table_b)
or field_a in ( select field_2 from table_b)