INSERT INTO VEHICLE2
      (AGENCYID, V2_DIRECTION)
       select avl.acdyear_number as AGENCYID,
              avl.vehicle_direction as V2_DIRECTION
        from acdu_vehicles_loc avl
        where avl.unit_nbr = '02';