Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

help with HQL query

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

mecha31

Post subject: help with HQL query

Posted: Fri May 08, 2015 6:00 am

Newbie

Joined: Thu May 07, 2015 5:49 am
Posts: 2

I have 3 tables :

User ---- many to many------ Userapp ------ many to many ----------- Application

User have :
- userId
- userName

UserApp :
- userId
- applicationId

Applicaiton :
- applicationId
- applicaitonName

I didn't success to create a HQL query for grab every User who get one application.

My HQL :

Code:

select a.userId, a.userName from Application b join b.userId a where b.userId = 1

Simplify query i would like to do :

Code:

from Application WHERE Userapp.userID = 1

could you help me please :) ?

Regards

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