When count() is 0, I still need to display something

Question

I have built a query that returns a possible 4 rows and 2 columns. One of the columns is a count of the number of times row n column 1 exists in the table. So my results look something like: foo 10 foo2 12 foo3 4 foo4 6 The problem is that with they way my query works now, if say foo3 has a count of zero (0) I don't get that row back at all. The other part of the problem is that I am simply binding the SqlCommandReader to a DataGrid. I need to display all the rows, even if they are zero. Can someone point me in the right direction for how I might handle this?