my project is of hotel booking..

Question

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

Nitin Sontakke · Answer

Is your original question got answer with the query I provided? Please feel free to modify the query as required.

Bikesh Srivastava · Answer

I think its totally depend on you and your team. and also if you will do this that will be better than other suggestionso try to understand and set up your mind to create DB structure.

Heni Sanghvi · Answer

And ya it has multiple hotels

Heni Sanghvi · Answer

But not possible with hotel name?? Table are same as u said just hotelid not there....there is hotelname

Nitin Sontakke · Answer

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