Home » SQL & PL/SQL » SQL & PL/SQL » outer join (oracle 10g , windows )
outer join [message #383393] Wed, 28 January 2009 12:01 Go to next message
Messages: 153
Registered: May 2005
Location: Giza
Senior Member

hi ,

i want to retrive the sum values of paid donations for each donation type to display it in report , but i need to display the donation type which have no values also
so , i wrote this statment but returned with the types which have paid values only .

from collection_detail c, collection b,donation_type d
where c.ID = b.INSTALL_ID
and c.TYPE_ID (+) = d.TYPE_ID

any advise
Re: outer join [message #383402 is a reply to message #383393] Wed, 28 January 2009 15:09 Go to previous message
Messages: 25568
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
So we can help you & please be consistent & correct in your postings.

Post DDL for tables.
Post DML for test data.

Post expected/desired results.

Previous Topic: Insert and creation of archive redo logs
Next Topic: How can u speed up a DROP TABLE process
Goto Forum:

Current Time: Thu Aug 17 06:55:16 CDT 2017

Total time taken to generate the page: 0.12089 seconds