Hibernate Community • View topic - Translating mySQL Query to HQL

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Translating mySQL Query to HQL

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

Grillkohle

Post subject: Translating mySQL Query to HQL

Posted: Mon Dec 07, 2009 12:34 pm

Newbie

Joined: Mon Dec 07, 2009 12:26 pm
Posts: 1

Hey,

basically I'm trying to convert the following, working as intended mySQL query to HQL, so far with little luck:

Code:

select * from jos_users where 
id exists (select id from jos_users as ju left outer join city_citizen as cc
on ju.id = cc.jos_users_id where jos_users_id IS NULL)

Maybe someone can help with 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