I am using Jsf with Hibernate .I have Column Named CaseNo in Table EventMaster
(It is concatenation of Case No "of " Year I am fetching CaseNo from CaseMaster and Year from YearMaster ) .Now I wanted to Sort this column How can I achieve this .

I wanted to add .addOrder(Order.asc("CaseNo")) but it is present in another Table

<rich:dataTable value="#{eventMaster.eventMasterList}" var="event" id="table"
rows="10" rowClasses="even-row, odd-row ">
<rich:column style="width:7%;">
<f:facet name="header">#{lbl['label.casenumber']}</f:facet>
<h:outputText value="#{event.caseNo}"/>
</rich:column>

<rich:column style="width:12%;">
<f:facet name="header">#{lbl['label.scheduleevent']}</f:facet>
<h:outputText value="#{event.eventDateString}"/>
</rich:column>

Criteria crt = session.createCriteria(merc.dao.EventMasterDao.class).add(Restrictions.eq("isDeleted", "N")).addOrder(Order.asc("eventDate"));
fetchList = (ArrayList<EventMasterDao>) crt.list();



@Entity
@Table(name = "event_master", schema = "mercdb")
public class EventMasterDao implements java.io.Serializable {

private Integer eventId;
private Integer casesId;
private Integer eventTypeId;
private Timestamp eventDate;

@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name = "EVENTID")
public Integer getEventId() {
return eventId;
}

public void setEventId(Integer eventId) {
this.eventId = eventId;
}

@Column(name = "CASESID")
public Integer getCasesId() {
return casesId;
}

What I am exactly looking for is

select * from event_master e,Case_master c
where c.caseId=e.caseId
and e.isDeleted='N'
order by e.eventDate asc , c.CaseNo desc

Can someone Help?????????????????????????????