Hibernate Community • View topic - does hbm have an "IN" where clause?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

does hbm have an "IN" where clause?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

nick5454

Post subject: does hbm have an "IN" where clause?

Posted: Mon Apr 05, 2010 2:04 pm

Newbie

Joined: Thu Mar 26, 2009 8:50 pm
Posts: 5

Hi i'm try to execute an "IN" inside the where

Does hbm have something like the "IN" caluse in sql

Ex in sql

select * from Authors
where Authors.PublisherId IN ( select PublisherId from Publisher where State = 'TX' )

That selects all Authors that have a Publisher located in Texas.

Is that possible to write as an hbm query?

Top

kir

Post subject: Re: does hbm have an "IN" where clause?

Posted: Tue Apr 06, 2010 2:36 am

Beginner

Joined: Fri Feb 27, 2009 6:07 am
Posts: 38
Location: Moscow,Russia

http://nhforge.org/doc/nh/en/index.html#queryhql-subqueries

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » NHibernate 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