我有两个名为NO2_avg和temperature_avg的表,我试图在公共列DATE(100)上连接这些表,但我得到了以下错误.
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"DATE(`Date Time`)" = a2."DATE(`Date Time`)"' at line 4
表格信息:
NO2_avg
+----------------------+-------------------+----------+--------------------+
| Location | DATE(`Date Time`) | COUNT(*) | avg(NO2) |
+----------------------+-------------------+----------+--------------------+
| Temple Way | 2017-09-07 | 24 | 27.305995000000006 |
| Parson Street School | 2017-09-07 | 24 | 32.020833333333336 |
| Fishponds Road | 2017-09-07 | 24 | 39.125 |
| Wells Road | 2017-09-07 | 24 | 41.354166666666664 |
| Brislington Depot | 2017-09-07 | 24 | 23.09375 |
+----------------------+-------------------+----------+--------------------+
temperature_avg
+-------------------+----------+-------------------+
| DATE(`Date Time`) | COUNT(*) | avg(Temperature) |
+-------------------+----------+-------------------+
| 2017-09-07 | 48 | 4.791666666666667 |
| 2022-03-04 | 48 | 5.333333333333333 |
| 2022-03-03 | 48 | 7.5625 |
| 2022-03-02 | 44 | 7.090909090909091 |
| 2022-03-01 | 48 | 5.791666666666667 |
+-------------------+----------+-------------------+
我使用的查询:
SELECT `avg(NO2)`
FROM
NO2_avg a1
INNER JOIN Temperature_avg a2 ON a1."DATE(`Date Time`)" = a2."DATE(`Date Time`)";
请帮帮我...