生成视图报错

zhangql8

SELECT bio_devices.iot_id, bio_devices.Nickname, bio_devices.Status, bio_device_temperature.iot_id AS iot_id_bio_device_temperature_iot_id, bio_device_temperature.productkey AS iot_id_bio_device_temperature_productkey
        , bio_device_temperature.devicename AS iot_id_bio_device_temperature_devicename, bio_device_temperature.bettery AS iot_id_bio_device_temperature_bettery, bio_device_temperature.temperature AS iot_id_bio_device_temperature_temperature, bio_device_temperature.net_status AS iot_id_bio_device_temperature_net_status, bio_device_temperature.samplerate AS iot_id_bio_device_temperature_samplerate
FROM bio_devices
        LEFT JOIN (select * from (select * from bio_device_temperature as t order by t.sample_time desc) as t1 group by t1.iot_id )as bio_device_temperature ON bio_devices.iot_id = bio_device_temperature.iot_id

数据库工具中测试没问题，动态数据集中测试报错。
查询语句测试未通过
Unknown column 'main_bio_device_temperature.iot_id' in 'field list'

gaofan

提示字段不存在，检查下对应字段是否存在。

zhangql8

gaofan 发表于 2020-2-28 09:23
提示字段不存在，检查下对应字段是否存在。

请关闭