TRUNCATE ppl2agenda;
INSERT INTO ppl2agenda (ppl_id, agenda_id) SELECT ppl_id, agenda_id FROM ppl JOIN lln2agenda ON lln2agenda.lln_id = ppl.login;
INSERT INTO ppl2agenda (ppl_id, agenda_id) SELECT ppl_id, agenda_id FROM ppl JOIN doc ON doc.afkorting = ppl.login JOIN doc2agenda ON doc2agenda.doc_id = doc.id;