Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Other Development Tools  Date

Author  Topic  tanmayee Starting Member 1 Post Posted - 2005-12-31 : 02:46:02 Hello Everybody, I'm doing a Room Booking Details project. The main aim of the application is to allow the user to block a room according to the availability of a room. I use 3 tables . The first one is Member Details. It contains the information about the members who block the rooms. It has got 5 fields. 1.Member_Id(Primary Key) 2.Member_Name 3.Address 4.E-mail 5.Phone_No. The second one is Booking Details. It contains the information about the rooms which has been blocked by the user from a specific date to another specific date. It has got 5 fields. 1.Member_Id 2.Check_In_date 3.Check_out_date 4.Room_id 5.Room_Status The third one is Room Details. It contains the information about the rooms and thiir names. It has got 2 fields. 1.Room_Id 2.Room_Name Now Please help me write a query which will allow a user to see the availability of rooms for each date. For eg: If a user wants to book a room between 31st of Dec to 1st Jan ...He should be able to see all the room with thieir Status i.e..if it is available or not. Please help me. Tanmayee.