mysql 嵌套查询，一个表的多个字段 作为另一个表的条件，求高手

SELECT daan
FROM 表A

WHERE daan IN (SELECT 选项1,选项2 FROM 表B)

 SELECT daan
FROM 表A,表B

WHERE daan=选项1 or daan=选项2

SELECT T1.daan
FROM 表A T1
    INNER JOIN 表B T2 ON T1.daan = T2.选项1 OR T1.daan = T2.选项2