Show all names in first column and insert zero where no record exists

[vbaInet]

Duly noted namliam although as vbaInet will tell you my ability to identify the wrong solution to almost any situation is now becoming legendary

I wonder if the wife is of the same opinion

A little bit of information about subqueries:
http://allenbrowne.com/subquery-01.html
http://allenbrowne.com/subquery-02.html