Home » Developer & Programmer » Reports & Discoverer » i need help in oracle discoverer 10g (oracle discoverer 10g,windows xp)
i need help in oracle discoverer 10g [message #378718] Wed, 31 December 2008 21:53 Go to next message
Messages: 1
Registered: December 2008
Junior Member
i need help in oracle discoverer 10g, i need to dispaly data from 2 tables having an internediate table in between them, for example table1 , table2 and table3:
table1 is the master of table2 and table2 is the master of table3, i need to calculate the count of the primary key in table1 and summaries from table3, when i dont include table2 in the report , the count becomes the count of occurance of the primary key of table1 in table3, i found that i must include table2, but i dont need to display any data from it,
can anyone please help me and tell me what to do?

[Updated on: Wed, 31 December 2008 21:55]

Report message to a moderator

Re: i need help in oracle discoverer 10g [message #378771 is a reply to message #378718] Thu, 01 January 2009 09:35 Go to previous message
Messages: 1
Registered: January 2009
Location: Egypt
Junior Member

sometime we need to join with a table that we don't need any data from except making the desired join. so you should include the table2 in your query even you don't need any data from . it's pereferrable to make a view based on your query and then use this view in the discovere as the data source.
Previous Topic: Serial Number in Group report
Next Topic: Report 6i
Goto Forum:

Current Time: Wed Oct 26 11:15:23 CDT 2016

Total time taken to generate the page: 0.10291 seconds