I have 2 tables. 1 for properties and 1 for dates. The dates table has a list of dates for when a property is booked and therefore not available for rent.
I would like users to be able to select a size of property (number of bedrooms) and the dates they want to stay.
I have never worked out how to use SQL Joins and I suspect it is needed now. Also I have to display the properties that are not booked (obviously!) is there an SQL statement where the value doesn't exist?
So for example select 2 bedroom properties where dates aren't in a date range. The users dates I suspect would need to be in an array how can I compare those with the value in the tables?