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 http://www.liquibase.org/documentation/changes/custom_change.html to write Java code to do whatever you need.
Nathan
