• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Resultset

 
bahri sirine
Ranch Hand
Posts: 33
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm trying to know how many objectid in the resultset 1 have the same objectid in the Resultset 2.When I execute this I obtained just the objectid which are places in the same Rowin two tables .So any help please how can I correct this.


 
Roel De Nijs
Sheriff
Posts: 10662
144
AngularJS Chrome Eclipse IDE Hibernate Java jQuery MySQL Database Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you please explain what you are trying to do? Because your current code makes very little sense.

Firstly, this use case seems very weird: why would you check if "id" of "professeur" matches with "id" of "etudiant"? These are both completely unrelated.

Secondly, instead of doing this logic in Java code (and iterating 2 resultsets), you should write 1 query which returns you the result immediately.
 
Roel De Nijs
Sheriff
Posts: 10662
144
AngularJS Chrome Eclipse IDE Hibernate Java jQuery MySQL Database Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
On a second glance I saw both tables are in different databases. Why?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic