my project is of hotel booking..

Heni Sanghvi

9y942

I have two tables room and room booking....room tables fields are roomid,hotelname,roomtype,roomdescription,roomfacility,roomphoto and roomprice And roombooking fields are clientname,hotelname,checkindate,checkoutdate,noofroom,noavailableroom,price I want search is there any data room available.. And it's new project so roombooking has no data So plz help in query

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke9y ago
Is your original question got answer with the query I provided?

Please feel free to modify the query as required.
0
Bikesh Srivastava9y ago
I think its totally depend on you and your team.
and also if you will do this that will be better than other suggestion,so try to understand and set up your mind to create DB structure.
0
Heni Sanghvi9y ago
And ya it has multiple hotels
0
Heni Sanghvi9y ago
But not possible with hotel name?? Table are same as u said just hotelid not there....there is hotelname
0
Nitin Sontakke9y ago
In my opinion, your tables doesn't look good. Why is HotelName should come in any of the tables? Is it it a multi-tenancy application? Meaning a system which would be used by many hotels? If yes, then you should have only Ids and play with these Ids only.

For example: tblHotel, tblHotelRoom, tblClient, tblClientBooking, etc. Each will have it's own Id column and only that column will be copied in every other column. So no HotelName in more than one table, which tblHotel. Hope you get it.

tblHotel -> Id, HotelName, Address, Phone, Email, etc. Everything about hotel and nothing else.

tblHotelRoom -> Id, HotelId (from above), RoomTypeId, RoomPriceId, etc.

tblClient -> Id, Name, Contact details, etc.

tblClientBooking -> Id, ClientId, HotelRoomId, DateFrom, DateTo, etc.

Now, to answer your question:

select *
from tblHotelRoom hr
left outer join tblClientBooking cb on hr.Id = cb.HotelRoomId
where cb.HotelRoomId is NULL
0