create or replace view sim_data_view
as
select
    sd.id_sim_data,
    sd.id_sim_info,
    sd.time_since_beg,
    sd.current as 'sim_current',
    sd.batt_left_volt as 'sim_batt_left_volt',
    sd.batt_right_volt as 'sim_batt_right_volt',
    sd.batt_left_temp as 'sim_batt_left_temp',
    sd.batt_right_temp as 'sim_batt_right_temp',
    ld.current as 'log_motor_curr',
    ld.batt_left_volt as 'log_batt_left_volt',
    ld.batt_right_volt as 'log_batt_right_volt',
    ld.gps_latitude,
    ld.gps_longitude
from
    sim_data sd
        join log_data ld
        using(id_log_data)
;