Prompt using SQL statement
I am trying to limit what shows on the prompt for a report.
We are using two books of business and only want to show the Product Categories for one book of business on the prompt.
SELECT "Product Category"."Parent Product"
FROM "Product Code Detail Lists"
WHERE "Product Category"."Parent Product 8" = "Graham - Batavia"
Below is the ananlytics area that is being used to create the report.
Active Subject Area:
Product Code Detail History
Created By
Created Date
.Description