In this recipe, you will learn the use of the Text file output step for writing text files.
Let's assume that you have a database with outdoor products and you want to export a catalog of products to a text file.
For this recipe, you will need a database with outdoor products with the structure explained in Appendix, Data Structures.
Carry out the following steps:
SELECT innerj.desc_product, categories.category, innerj.price FROM products innerj INNER JOIN categories ON innerj.id_category = categories.id_category