Re: trigger new row join other table

[Peter Brawley]

Something like this?

create trigger after update on b for each row
begin
  set @ctry = (select country_id from c where province_id=OLD.province_id );
  update a 
    set country_gdp = country_gdp+NEW.province_gdp-OLD.provionce.ggp
    where country_id=@ctry;
end;

Edited 1 time(s). Last edit at 01/08/2014 03:50PM by Peter Brawley.