Hi All.
I have a blonde moment.
My project contains 6000 records of visits to properties, and I want to query any property that has not been visited in 3 last months
Table one Sites - field 'Propertiesid'
table two ( child of table one) 'visits' - update field (date)
Outcome = which of the properties have not had a visit in last 3 months.
phprunner 10.91 / mysql db
I have a complete blank on this, would anyone be able to help me please?