Hi guys, I have a question regarding a join in oracle 8. Is this an apropriate place to ask for help regarding it?
In any case! :)) http://pastebin.com/ZNx00c9k is my query.. it fetches the data i want. My issue is though.. If a record exist in t2 (the budget table) but there are no matching records in the balance table (t1) It's not showed in the result. How can i re-write the query so it will show this record aswell? (Several records exist in t1 with no matching records in t2, so it's not just a case of reversing the join)