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
rehab_sakna
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
weloooo
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.

Report message to a moderator

Previous Topic: Serial Number in Group report
Next Topic: Report 6i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 05 10:16:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.