begin .. for each row in other table{ } ... end

[davy timmermans]

in pseudo code:

create trigger medewerker_helper after instert on medewerker

BEGIN

for each row in salesman: (=other tabel)
set @id = select sid from salesman

INSERT INTO medewerkerUsers VALUES( @i,new.cid , 'I');
END



Edited 1 time(s). Last edit at 03/30/2006 06:08PM by davy timmermans.