We have no idea what data you have in your tables, so only the guess:
You join on dates, so it may be that some dates in your expected data are such that they are not covered by the join.
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]