Hibernate Community • View topic - Subquery where exists (...)

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Subquery where exists (...)

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

Cicel

Post subject: Subquery where exists (...)

Posted: Fri Jun 01, 2007 5:39 pm

Newbie

Joined: Fri Jun 01, 2007 5:31 pm
Posts: 1

Hi,

I'm using SqlSelectBuilder because I want to use ANSI SQL with unmapped tables.

Is there any solution to use something like:

Code:

select id from MyTable1 where exists (
  select id from MyTable2 where...........)

An example will be very usefull.

I don't want to use join because in reality the query is something like:

Code:

select id from MyTable1 where name='John' OR exists (
  select id from MyTable2 where...........)

Thank you very much!

Top

Page 1 of 1

[ 1 post ]

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