Mine

SELECT `RotaSchedule`.`RotaID`,`RotaSchedule`.`Datestamp`,`RotaSchedule`.`SpecificHour`,`RotaSchedule`.`MinutesVaried`,`RotaSchedule`.`CustomName`,`Individual`.`ID`,`Individual`.`Name` FROM `RotaSchedule`,`Individual` WHERE RotaSchedule.IndividualID = Individual.ID AND RotaSchedule.Datestamp >= $week AND RotaSchedule.Datestamp < $nextweek;