Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.03 » View Incident Report |
Serious |
Reported By: Erich Munz Reported On: 4/19/2010 For: Version 2.03 Build 11 |
SELECT k.id_Kunde, k.LfNummer, k.Kurzzeichen, SUM(IF(b.BelegArt IN (3,5) THEN b.Summe ELSE -b.Summe)) as Gesamtumsatz FROM kunden k INNER JOIN (SELECT belegart, lfnummer, id_Beleg, id_Kunde, Summe, Datum FROM belege WHERE belegart IN (3,5,8) AND Datum BETWEEN :datumVON AND :datumBIS) b ON (b.id_Kunde = k.id_Kunde) GROUP BY k.LfNummer ORDER BY Gesamtumsatz DESC, k.Kurzzeichen
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 |