SELECT u.code,u.name,p.pm10,d.voltage1 FROM t_device AS u LEFT JOIN (t_device_r_data AS p LEFT JOIN t_r_airelectryvalue AS d ON p.code=d.code) ON u.code=p.code ;
mysql 三个表级联查询,以主表为主数据表为辅
最新推荐文章于 2024-06-18 08:41:53 发布
SELECT u.code,u.name,p.pm10,d.voltage1 FROM t_device AS u LEFT JOIN (t_device_r_data AS p LEFT JOIN t_r_airelectryvalue AS d ON p.code=d.code) ON u.code=p.code ;