I have defined <many-to-one> relation for RewardsID in Points History Table as shown below in .hbm.xml file.

My requirement is to retrieve points history between particular dates. Given below is the HQL that I am using.
select
pnt.createdDate,
pnt.points,
pnt.rewardsChart.name,
pnt.rewardsChart.description,
from PointsHistory pnt where pnt.createdDate between ? and ?

The problem that I am facing with this query is that it only returns the rows from points history table where RewardsID is not null. Is there any way in which we can retrieve all the desired rows?

Given below are the mapping files and query along with the problem/question that i have:

RewardsChart Table
RewardsID – Primary Key
Name
Description
.
.
.

Points History Table
PointsHistoryID - Primary Key
UserID
Points Awarded/Redeemed
RewardsID – nullable foreign key. If Points have been redeemed, thn this column would be populated with the RewardsID from Rewards Table (given above). If points have been awarded, thn this column would have null value
CreatedDate
.
.
.
.

RewardsChart.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="xxx.RewardsChart"
table="RewardsChart">
<cache usage="read-write" />
<id name="rewardID" type="integer">
<column name="RewardsID" />
<generator class="identity" />
</id>

<property name="name" type="String">
<column name="Name" />
</property>

<property name="description" type="String">
<column name="Description " />
</property>
</class>

</hibernate-mapping>

PointsHistory.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="xxx.PointsHistory"
table="PointsHistory">
<cache usage="read-write" />
<id name="pointsHistoryID" type="integer">
<column name="PointsHistoryID" />
<generator class="identity" />
</id>

<many-to-one name="userID" column="UserID" />

<property name="points" type="long">
<column name="Points" />
</property>

<many-to-one name="rewardsChart" column="rewardsID" not-found="ignore" not-null="false" />

<property name="createdDate" type="timestamp">
<column name="CreatedDate" />
</property>
</class>

</hibernate-mapping>


If i remove following fields from the query, it works as desired:
pnt.rewardsChart.name,
pnt.rewardsChart.description,


Thanks in advance...

You should use an outer join for this

It worked...Thanks for help...Really appreciate it...