mysql - mysql中一张表的两条select语句的交集

Question

在条款中

SELECT *  FROM build_req WHERE version = "8.2.0.1" IN (SELECT * FROM 
build_req where build_status = "Approval Pending");

错误

操作数应包含 1 列

联合

SELECT *  FROM build_req WHERE version = "8.2.0.1" union SELECT * FROM 
build_req where build_status = "Approval Pending";

工会运作良好。我该如何克服这个错误？

Answer 1

您错过了 where 条件 and id IN 并且 SELECT * FROM 将在您只需要一列的 where 条件下给出所有列

SELECT * FROM build_req WHERE version = "8.2.0.1" and build_status = "Approval Pending" ;