• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Cant achieve this simple query

 
amro talaat
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have 2 tables

Room and GuestRoom


Room

RoomId--Number Of Rooms-Price



GuestRoom

RoomId-GuestId-StartDate-EndDate



I want to query all rooms that has mutual RoomId ON GuestRoom.
 
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
And what did you have tried yourself? On which part of the query you are stuck (and/or having an issue with)?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic