Ronald H (9/27/2011)

---

Then I think you simply have to add

OR ClientRoom.ClientRoomNo IS NULL

for rooms that have no reservations at all. You can use any other column in ClientRoom for...

NO it dos not have...

ROOM TABLE

PK - RoomNo

- RoomTypeNo

- RoomStatusId

CLIENTROOM TABLE

PK - ClientRoomNo

FK - RoomNo

- ArrivalDate

...

If I include the where clause on the query, It only filters the CLIENTROOM Table,

When I dont inlcude it.. It returns all ROOMs without filters.

I want to select all available room on a specific time..

WHERE ((ClientRoom.ArrivalDate NOT BETWEEN '2011-09-28 8:00:00' AND '2011-09-28 10:00:00') AND

(ClientRoom.DepartureDate NOT BETWEEN...

Sean Lange (9/22/2011)

---

TheOxblood (9/22/2011)

---

So, you are saying that the availability of the rooms will depend on the reservation time of the other?

SELECT * FROM Table WHERE ArrivalDate <> ... AND...

steveb. (9/22/2011)

---

TheOxblood (9/22/2011)

---

steveb. (9/22/2011)

---

I wouldn't store the room status (if status is meant to indicate if the room is avialable or not) I would store the...

I made a modifications on my database, would this be more good?

steveb. (9/22/2011)

---

I wouldn't store the room status (if status is meant to indicate if the room is avialable or not) I would store the rooms and the...

So, you are saying that the availability of the rooms will depend on the reservation time of the other?

SELECT * FROM Table WHERE ArrivalDate <> ... AND DepartureDate <> ...?

Yes...

Yes i am planning to merge it..

Yes it is for hotel reservation! 🙂

How can I allow per each room their status?

For example, RoomNo 10 is RESERVED at 7:00am-12:00pm

but 12:00pm onwards,...

oh! I forgot to remove the Status on the Reservation Table.. Sorry!

I need to retrieve all available rooms? do i need to create a new table?

how and what are the...