Hibernate Community • View topic - Comparing 2 tables HQL

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Comparing 2 tables HQL

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

abdelmonaembenammar

Post subject: Comparing 2 tables HQL

Posted: Tue Sep 13, 2011 10:39 am

Newbie

Joined: Tue Sep 13, 2011 10:15 am
Posts: 3

Hi,

I want to compare 2 tables and have as Result : the difference between them.
I mean the data that didn't existe in fisrt (PERSON) one comparing to the second one (AUTHENTIFICATION).

Code:

PERSON
  - id
  - name
  - tel
  - ...

Code:

AUTHENTIFICATION
  - idaut
  - Login
  - mpass
  - FKpersonneid

there is a join between the using : FKpersonneid

I tried this, but id'oesn't work !

Code:

List<Person> lstpers=HibernateTemplate.find(FROM Person WHERE id NOT IN (FROM AUTHENTIFICATION));

I don't find the true QHL syntaxe to create the querry

Top

abdelmonaembenammar

Post subject: Re: Comparing 2 tables HQL

Posted: Wed Sep 14, 2011 6:08 am

Newbie

Joined: Tue Sep 13, 2011 10:15 am
Posts: 3

Someone can Help ?

Top

Page 1 of 1

[ 2 posts ]

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