How to query available rooms in Hotel Reservation System?

[Obie Okala]

I want the user to be able to put a date and search, and only the available rooms for that date should show. Any room that had been previously booked should not show.
I'm using C# and Sql Server, and have a BOOKING TABLE and ROOMS TABLE(Which has arrival and Departure, and Room Names)

[Rabbit]

Ok. So try to do that and come back if you run into a specific problem.