56,940
社区成员




insert into etcvehiclerecord(userId,vehicleId,obuid,cardid)
select distinct o.userId , o.vehicleId ,o.id obuid ,c.id cardid from
obuupload o
left JOIN cardupload c ON o.vehicleId = c.vehicleId and o.userId =c.userId
left JOIN vehicleupload v ON o.vehicleId = v.id and o.userId =v.userId;