it's quite an ancient system but an upgrade is at least 5 years away so we have to live with it. sorry, i simplified the query above as i didn't want to include more columns than necessary to illustrate. amending as below. If there are projects that do not have any Organization values (null?) then i still want them listed…

@Gianni Ceresa an oracle upgrade is at least 4 years away so we have to live with it. sorry I tried to use only the minimum columns just for illustration purposes and so might have been unclear with what i wanted. In the OBIEE query editor the SQL below produces a result showing project numbers with budgets. if you remove…