Insert into table if entry does not exist

Insert into table if entry does not exist

I want to create a changeset which inserts which iterates over all entries
of a table an looks into another table by the primaryKey. If in this table
there is no entry for that primaryKey, 2 inserts in 2 different tables
should be performed.
Greets and thanks for your help