SELECT
f.vin AS vin,
o.NAME AS NAME,
v.plate_no AS plate_no,
f.stat_day AS stat_day
FROM
lqcv_analysis.lqcv_fault_stat_inday f
INNER JOIN lqclw.vehicle v ON f.vin = v.vin
INNER JOIN lqclw.customer_organization o ON f.org_id = o.id
GROUP BY
vin,
NAME,
stat_day
ORDER BY
vin,
stat_day ASC
mysql多表联查
最新推荐文章于 2024-04-30 17:49:31 发布