Hibernate Community • View topic - Criteria query for outer join to subquery

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Criteria query for outer join to subquery

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

incrediblevicky

Post subject: Criteria query for outer join to subquery

Posted: Mon Aug 01, 2011 5:47 am

Newbie

Joined: Mon Aug 01, 2011 5:23 am
Posts: 1

Hi,

I have two tables TABLEA and TABLEB

TABLEA : int id, String val.
TABLEB: int id, String logs, int a_ref

I need to create a query such as :-

select tabB.* from TABLEB tabB
left outer join (select tabA_.ID from TABLEA tabA_) attr on attr.ID = tabB.a_ref;

Can somebody please help me how to create a criteria query in hibernate for this.

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

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