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 models.
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.
Any help?