Hibernate Community • View topic - HQL Union and order by

View unanswered posts | View active topics

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

HQL Union and order by

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

namrata014

Post subject: HQL Union and order by

Posted: Wed Aug 26, 2009 4:55 am

Newbie

Joined: Tue Jun 09, 2009 7:54 am
Posts: 10

Hi all,

I have two different tables:
Supplier
id
supplier_name
joining_date

Customer
id
customer_name
joining_date

I need to get data from both these tables using a union and order ALL the results on basis of the joining_date.

An equivalent in sql would be

Code:

select r.id, r.joining_date from
    (select id, joining_date from customer union
    select id, joining_date from supplier) r 
order by r.joining_date

How do I achieve this in HQL??
Please help.

Top

hardy.ferentschik

Post subject: Re: HQL Union and order by

Posted: Wed Aug 26, 2009 5:11 am

Hibernate Team

Joined: Thu Apr 05, 2007 5:52 am
Posts: 1689
Location: Sweden

Wrong forum mate. This is a question for the Hibernate Users forum.

Top

Page 1 of 1

[ 2 posts ]

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum