Search results

Hi, I tried to get the max date value, but I got an error - Cannot have aggregate function in WHERE clause (((Room.status)="free") AND ((Max([Reservation.date_checkout]))>=Date())); Code: UPDATE Room INNER JOIN Reservation ON Room.id_p = Reservation.room SET Room.status = "occupied" WHERE...