Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.03 » View Incident Report |
Serious |
Reported By: Tim Young Reported On: 10/29/2009 For: Version 2.03 Build 4 |
SELECT FA.FIRMENNUMMER,FA.ABTEILUNGSNUMMER,F.NAME1, A.BEZEICHNUNG, A.NUMMER AS ABTNR, A.Leiter, P.ID , F.NUMMER AS FIRMENNR , P.ABTEILUNG, P.NAME, P.VORNAME, P.NUMMER as PNUMMER, P.NAME, P.KARTENNR , P.EINTRITTSDATUM, P.AUSTRITTSDATUM, P.KOSTENSTELLE1, F.ORT, P.ISTANWESEND FROM FA_ABT FA LEFT OUTER JOIN SD_PERS P ON ((P.FIRMENNR = FA.FIRMENNUMMER) AND (P.ABTEILUNG = FA.ABTEILUNGSNUMMER)) RIGHT OUTER JOIN SD_FIRM F ON ( FA.FIRMENNUMMER = F.NUMMER ) LEFT OUTER JOIN SD_ABT A ON ( FA.ABTEILUNGSNUMMER = A.NUMMER ) ORDER BY F.NAME1, A.BEZEICHNUNG, P.NAME, P.VORNAME, P.NUMMER , P.ID
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 |