![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Addressed for Version 4.16 » View Incident Report |
![]() |
Reported By: Ian Turner Reported On: 12/12/2004 For: Version 4.15 Build 1 |
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
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |