Steve and all, nicely done!!!

I find the use of the additional "filter" in the ON clause facinating...

"...left outer join orders o

on c.customerid = o.customerid

and datepart(m, o.orderplacedate) = 10..."

I use A LOT of left outer joins in my work and this is the first time I've seen this type of qualifier embedded in the table join qualifier.