Thanks for the code and I have tried it, but it still does not return the null value as 0.

For the NVL, I thought it will return 0 if there is a null value.

I will post again if I find the solution.

Hi, I am new to SQL and I need help to display null value as 0.

Problem description:
The query is to display Branch Code, Branch Location, Account Type Code, account Type Description and Total Current Values of each type of account. The report also needs to show a total of zero if the account type is not currently in use at that branch - ie. all branches should have two entries, one for Savings and one for Term Deposits....