MySQL 子查询结果数组

Question

我想使用 table_1 上选择的 (id_1)id 数组来获取 table_2 中 id_2 = id_1 的所有行

  SELECT field_b
  FROM table_2
  WHERE id_2 IN (
         SELECT id_1 FROM table_1 WHERE field_a = 1234
  );

以下是我的表格示例以供引用:

  mysql> select * from table_1;
    +-------+---------+
    |  id_1 | field_a |
    +-------+---------+
    |     1 |    1234 |
    +-------+---------+
    |     2 |    1234 |
    +-------+---------+


mysql> select * from table_2;
+---------+---------+
|    id_2 | field_b |
+---------+---------+
|     1   |  5678   |
+-------+-----------+
|     2   |  0013   |
+-------+-----------+

Answer 1

INNER JOIN 是否也适合您？

SELECT field_b
FROM table_2
INNER JOIN table_1
    ON table_2.id_2 = table_1.id_1
WHERE table_2.field_a=1234