mysql - 如何将这两个查询合并在一起？

Question

SELECT MIN( a.severity ), CONCAT_WS(",", a.dev_id, a.object_id ) AS tuple 
FROM net.alerts AS a INNER JOIN net.deviceinfo AS c ON c.id = a.dev_id AND 
c.peer = ( SELECT value FROM local.settings WHERE setting="server_id" ) WHERE 1 
AND (a.dev_id, a.object_id) IN ( (13,4164),(45,-1),(145,995),(188,-1) ) GROUP BY tuple


SELECT MIN( a.severity ), CONCAT_WS(",", b.device_id, b.object_id ) AS tuple 
FROM net.alerts AS a INNER JOIN local.conditions AS b ON a.condition_id = b.condition_id WHERE 1 
AND(b.device_id, b.object_id) IN ((13,4164),(45,-1),(145,995),(188,-1) ) Group BY tuple

我有这些表，在警报和条件表中，它们都有 device_id 和 object_id，但它们可能不同，所以我正在尝试检索该组合的所有数据。

Answer 1

我不确定我明白你想做什么，但我想你需要使用 UNION .

顺便问一下，为什么要写 WHERE 1 AND condition 而不是 WHERE condition ？