Mysql合并两个sql结果

最新推荐文章于 2024-05-21 20:01:33 发布

huayang183

最新推荐文章于 2024-05-21 20:01:33 发布

阅读量2.1k

点赞数 1

分类专栏： MYSQL

FZY

本文链接：https://blog.csdn.net/qq_18671415/article/details/118293042

版权

MYSQL 专栏收录该内容

145 篇文章

订阅专栏

第一条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

结果展示：
在这里插入图片描述

第二条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

结果展示：
在这里插入图片描述

合并结果

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