Mysql合并两个sql结果

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

结果展示：