Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.02 » View Incident Report |
Serious |
Reported By: Uli Becker Reported On: 7/20/2009 For: Version 2.02 Build 15 |
select distinct PatientenID, Name,Vorname,GebDat,Anrede,Strasse,PLZ,Ort from informa.Patienten p join Anforderungen a on a.PatientenID = p.patientenID join informa.Scheine s on a.ScheineID = s.ScheineID where not (coalesce(PLZ,'') = '''' or coalesce(Strasse,'') = '' or coalesce(Ort,'') = '') and (abgerechnet = false and Ambulant = :true and Gruppe <> 'IM1') and (s.privat = true) order by Name, Vorname
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |