• 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: 10763
148
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)?
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!