SELECT History.DateStart, History.Duration, History.RoomNo,
History.WithPartner,
       Patient.Title, Patient.ChristName, Patient.Surname,
Patient.PatientCode,  Patient.DOB, Patient.Retired, Patient.Sex,
Rooms.RoomName, Photo.Photo
FROM "History" History
LEFT OUTER JOIN "PatPhoto" Photo
ON (History.PatientCode = Photo.PatientCode),
"Patient" Patient, "Rooms" Rooms
WHERE (((History.DateStart >= '2004-12-06')  AND (History.DateStart <=
'2004-12-12')) OR
      (((History.DateStart+History.Duration-1) >= '2004-12-06')  AND
((History.DateStart+History.Duration-1) >= '2004-12-12'))
       AND ( History.LocCode = 'HARR' )
AND (Patient.PatientCode = History.PatientCode)
       AND (Rooms.LocCode = History.LocCode)
       AND (Rooms.RoomNo = History.RoomNo)

ORDER BY Patient.PatientCode