select concat('insert into UNIT_UNIT (KEY_SUB_UNIT, KEY_PARENT_UNIT) VALUES (',UNIT.ID_INTERNAL, ',' ,UNIT.KEY_PARENT_UNIT, ');') as ""
  from UNIT WHERE UNIT.KEY_PARENT_UNIT IS NOT NULL;