SELECT * FROM device d LEFT JOIN device_sys_user s ON d.id = s.DEVICE_ID WHERE 1 = 1 AND `DEVICE_STATUS ` = 2 AND s.`SYS_USER_ID` = 195
无法识别这个列,
`DEVICE_STATUS ` = 2改成
`DEVICE_STATUS` = 2
多写了一个空格。。。。
SELECT * FROM device d LEFT JOIN device_sys_user s ON d.id = s.DEVICE_ID WHERE 1 = 1 AND `DEVICE_STATUS ` = 2 AND s.`SYS_USER_ID` = 195
无法识别这个列,
`DEVICE_STATUS ` = 2改成
`DEVICE_STATUS` = 2
多写了一个空格。。。。