outer join [message #383393] |
Wed, 28 January 2009 12:01  |
RAY_HT
Messages: 155 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
|
|
|
|