Thanks, Matt.

I know for each row, it will return only the non-Nulls.

But my problem is that for all other rows which are non-Nulls, the query produces 0 as the count.

E.g.

Row 1 - 5 (Count from table B)

Row 2 - 0 (Count from table C)

Row 3 - 2 (Count from table B)

Row 4 - 6 (Count from table B)

Row 2 should have returned a value other than 0

Regards,

Afkas