查询已激活车辆的车架号和iccid

查询已激活车辆的车架号和iccid

        SELECT
	rtm_tbox.iccid,
	rtm_vehicle.vin
FROM
	rtm_tbox
LEFT JOIN rtm_vehicle ON rtm_tbox.imei = rtm_vehicle.imei
WHERE
	rtm_tbox.activate_state = 1
AND rtm_vehicle.del_flag = 0
AND rtm_tbox.del_flag = 0;