创建视图时有子查询报错

zhangql8

SELECT bio_device_temp.GmtOnline, bio_device_temp.Status, bio_device_temp_history.bettery AS fiot_id_bio_device_temp_history_bettery, bio_device_temp_history.pt100 AS fiot_id_bio_device_temp_history_pt100, bio_device_temp_history.sht3x_temperature AS fiot_id_bio_device_temp_history_sht3x_temperature
FROM bio_device_temp
LEFT JOIN (select * from (select * from bio_device_temp_history order by sample_time desc) group by iot_id)as  history ON bio_device_temp.iot_id = history.iot_id

gaofan

具体报什么错。

zhangql8

gaofan 发表于 2020-2-24 09:40
具体报什么错。

请关闭