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?

Andrzej Wegierski · Answer

Modify SQL expression to return row even if count=0. Something like it: SELECT keycount(*) cnt FROM slave UNION SELECT key0 cnt FROM master WHERE NOT EXISTS(SELECT key FROM slave WHERE slave.key=master.key) It works if You have [key] value in table [master]. SQL can't return a row if there's no data in table ...

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