Inserting a row, getting Foreign Key from another table.

Hello,


I am wirting a script to import data, i have 2 XML’s which contain book data and another which contains the page contents.


The script i have written produces the Liquibase changeSet’s.


I have an issue that i am inserting a book into 1 table and then when i come to insert the page there is a foreign key that i need to then select from the book table for the book that has just been inserted.


This i what i have so far:


Inserting the Book.


I tried using the SQL tag to run the query but i get a parsing error.


Has anyone got any ideas on how i can do this.


Thanks in advanced.


Ashley