Hi Friends, Following is the requirement for me

i am having two tables called vendor and dailyactivity
Total transactions done by a vendor for everyday will be stored dailyactivity table
now i need to get all the vendors and their transaction count if any in dailyactivity i.e it should return all the vendors and if they have transactions in dailyactivity it should return the value else it should return 0.

I heard that we can do this using left join, but i am not clear how to do that in hibernate