Paste code

insert into
  spec(name,tech_name)
select distinct
  v.`UPL_SPEC_NAME`,
  v.`UPL_SPEC_NAME`
  FROM
    v_prof_stud v
where
  v.`UPL_SPEC_NAME` not in
(
SELECT distinct
  v.`UPL_SPEC_NAME`
  FROM
    v_prof_stud v
left join
  spec s
  on s.`tech_name` = v.`UPL_SPEC_NAME`
 );
 
insert into
  univergroup(name,tech_name)
 select distinct
  v.`GR_NAME_GR`,
  v.`GR_NAME_GR`
  FROM
    v_prof_stud v
where
  v.`GR_NAME_GR` not in
(
SELECT distinct
  v.`GR_NAME_GR`
  FROM
    v_prof_stud v
left join
  univergroup s
  on s.`tech_name` = v.`GR_NAME_GR`
 );

 
insert into
 enrollment(name, tech_name)
 select distinct
  v.`AB_KAZ_NAME`,
  v.`AB_KAZ_NAME`
  FROM
    v_prof_stud v
where
  v.`AB_KAZ_NAME` not in
(
SELECT distinct
  v.`AB_KAZ_NAME`
  FROM
    v_prof_stud v
left join
  enrollment e
  on e.`tech_name` = v.`AB_KAZ_NAME`
 );