Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Infosauger
- Order by date
-
Prompts in multi-Report query
Here is an real world example: (sorry for any language mistakes) for each customer who has bought more than 10 parts of product 1display all products with sum. select customernumber, partnumber, sum(quantity) from customer c, transaction t where c.customernumber = t.customernumber and...- Infosauger
- Post #3
- Forum: Cognos solutions
-
Prompts in multi-Report query
Hello, i want to create a roport following style (sql) select a,b,f(c) from x where filters and a in (select a from x where filters and b = y group by a,b having f(c) = z group by a,b; so for all a having in b value z in f(c) display all b...- Infosauger
- Thread
- Replies: 3
- Forum: Cognos solutions
