Hello...this amounts more to SQL questions rather than Rails specific
I guess. I'm new to both.
Basically what I'm trying to do is perform a search for sites which
are available for a reservations system. I have a Sites model and I
have a Reservations model. Reservations contains columns for
checkindate and checkout date. I also created a model for Booking
status, which has columns for site_id and date to show which dates and
which sites are booked, but I'm not even sure I necessarily need this
table if there's a way to query just using the Sites and Reservations
The parameters I want to use at this point for the query is to let the
user choose a checkindate and a checkout date and I want to return a
list of sites which are available.