Hi,
I have a sql query where I give date range (from, to) as input and I want results of distinct count of users for all values of dates in that range, right now the sql would return only the values when its non zero, it would skip the date in the result set otherwise..
I want to get all dates in the result set and have a count as 0 if there is no value for that date.

I am assuming this will require doing a left join of users table on a "complete list of dates in the given date range", how do I go about doing this using hibernate?

users table: (id, currdate, userid)