Hi all, sorry if the title is confusing, I'm sure the question will be easy for someone out there ...
Below are two tables. I am left joining them on the Account field where table1.account = table2.account. Unfortunately, if the Account does not exist in the first table yet (Account hasn't been used yet this month) then I cannot get the Budget value for that Account from the second table. As you can see, in the second table, Account 3195 does not exist. NVL doesn't work. Even if I have to manually list the Account numbers (there are only 25 or so), I can do that if necessary for your solution.
Thank you for your expedient assistance!
| Account | Balance |
|---|
| 3100 | 10 |
| 3200 | 15 |
| 3300 | 20 |
| Account | Budget |
|---|
| 3100 | 100 |
| 3195 | 150 |
| 3200 | 200 |
| 3300 | 250 |