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)
;