In order to create a new XML document you can use the XML Output step. In this recipe, you will create a new XML file from a database containing books information.
You will need a books' database with the structure described in the Appendix,
Carry out the following steps:
SELECT id_title , title , genre , price , concat(lastname,", ",firstname) author FROM Books LEFT JOIN Authors ON Authors.id_author=Books.id_author