Posts by drmrkrch

Another way (older way) to join two oracle tables together with outer join syntax would be to do it the following way.

select c.companyname, sum(nvl(i.sales,0))
from customers c, invoices i 
where c.companyname = i.companyname (+)
group by c.companyname

The (+) syntax goes where you expect the nulls to occur