Databases Reference
In-Depth Information
approach is similar to the steps outlined in this recipe. Use the Category and Inventory
tables as the base for these pages.
To verify if what you've done is correct, you should have the List of Categories report
shown next. This will provide the storekeeper an interface to manage the list of available
book categories in the topic catalog.
For the inventory report, you should eventually have the report shown next. To display
the topic title in place of the topic ID in the report, you can use the following SQL:
select "ID",
"BOOKS"."BOOKTITLE" "BOOKID",
"COPIESINSTOCK"
from "#OWNER#"."INVENTORY" LEFT JOIN "BOOKS" ON "INVENTORY"."BOOKID"= "BOOKS"."BOOKID"
