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
RAY_HT
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 .

select b.BRANCH_ID,b.AREA_ID, d.TYPE_ID,c.VALUE
from collection_detail c, collection b,donation_type d
where c.ID = b.INSTALL_ID
and b.PAY_STATUS_CODE=3
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
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
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: Sun Dec 04 22:38:48 CST 2016

Total time taken to generate the page: 0.25701 seconds