Insert into table if entry does not exist

Hi all, 

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

There is nothing built into Liquibase for that out of the box. The tag gives you the ability to do anything you normally could in SQL, so depending on your database you may be able to find an SQL call that will do what you want. Otherwise, you can also use to write Java code to do whatever you need.