Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.02 » View Incident Report |
Minor |
Reported By: Jim Garrity Reported On: 12/16/2008 For: Version 2.02 Build 5 |
SELECT rptPatient.First_Name, rptPatientAddress.Mailing_Name FROM rptPatient rptPatient LEFT OUTER JOIN rptPatientAddress rptPatientAddress ON (rptPatientAddress.Owner_ID = rptPatient.Entity_ID) where rptPatientAddress.Mailing = true rptPatient: select Pat.*, extract(month from Date_of_Birth) as Birth_Month, EXTRACT(Year FROM Current_Date)- extract(Year from Date_of_Birth) as Age, Staff.Abbreviation as Clinician_Name, Off.Abbreviation as Office_Name, Prof.Abbreviation as Physician_Name from Patient Pat left outer join Staff on Pat.Clinician_ID = Staff.Entity_ID left outer join Office Off on Pat.Office_ID = Office.Entity_ID left outer join Professional Prof on Pat.Physician_ID = Prof.Entity_ID where Removed = false rptPatientAddress: select A.*, L.City, L.State_Code, L.Postal_Code from Address A left join Location L on A.Location_ID = L.Entity_ID where Removed = false and Owner_Type = 1
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |