Mysql合并两个sql结果

绝地灬酷狼 2022-10-10 11:27 165阅读 0赞

第一条sql及结果

SELECT  
value4 AS ‘压缩机功率’,  
create\_date AS ‘时间’  
FROM  
gree\_data  
WHERE  
data\_belong = ‘External\_05’  
AND create\_date > ‘2019-10-23 17:03:59’  
ORDER BY  
create\_date

结果展示：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE4NjcxNDE1_size_16_color_FFFFFF_t_70]

第二条sql及结果

SELECT  
value2 AS ‘工作模式’,  
value4 AS ‘室温’,  
create\_date AS ‘时间’  
FROM  
gree\_data  
WHERE  
data\_belong = ‘Internal\_18’  
AND create\_date > ‘2019-10-23 17:03:59’  
ORDER BY  
create\_date

结果展示：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE4NjcxNDE1_size_16_color_FFFFFF_t_70 1]

合并结果

SELECT  
a1.`压缩机功率`, a2.\*  
FROM  
(  
SELECT  
value4 AS ‘压缩机功率’,  
create\_date AS ‘date1’  
FROM  
gree\_data  
WHERE  
data\_belong = ‘External\_05’  
AND create\_date > ‘2019-10-23 17:03:59’  
ORDER BY  
create\_date  
) a1  
LEFT JOIN (  
SELECT  
value4 AS ‘风速设定’,  
value5 AS ‘室温’,  
create\_date AS ‘date2’  
FROM  
gree\_data  
WHERE  
data\_belong = ‘Internal\_18’  
AND create\_date > ‘2019-10-23 17:03:59’  
ORDER BY  
create\_date  
) a2 ON a1.date1 = a2.date2

结果展示：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE4NjcxNDE1_size_16_color_FFFFFF_t_70 2]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE4NjcxNDE1_size_16_color_FFFFFF_t_70]: /images/20221005/e2984ce2a66b4460a08c33506b487723.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE4NjcxNDE1_size_16_color_FFFFFF_t_70 1]: /images/20221005/8cc13fc3cc7045f6bb43fdb04374fb7a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE4NjcxNDE1_size_16_color_FFFFFF_t_70 2]: /images/20221005/5ef9dcba146846a5a4a89339b7b50a3a.png