SQL查询根据存储在另一个表中的数据从一个表中检索数据？

Question

有3个表格：table1，table2和table3。

查询是：

select column1 from table1 where [email protected] AND [email protected] 

这里，值1和值2存储在表中表2的整个数据和表3

Answer 1

试试这个

select colum1 
from table1 
where 
    variable1 in (select column2 from table2) and 
    variable2 in (select column3 from table3) 

Answer 2

的问题不是很清楚，但最接近的猜测是

SELECT column1 
FROM table1 
JOIN table2 ON table1.variable1 = table2.value1 
JOIN table3 ON table1.variable2 = table3.value2