branches_countries.sql

# migrate branch names -- 
INSERT INTO branches(name) 
  SELECT DISCTINCT(BranchName) 
  FROM 527433_iec.iec_branch;
 
# map country ids --
UPDATE branches b
  INNER JOIN 527433_iec.iec_branch ob
  ON ob.BranchName = b.name
  INNER JOIN 527433_iec.iec_country oc
  ON ob.country = oc.CountryId
  INNER JOIN countries c
  ON oc.CountryName = c.name
SET b.country_id = c.id;