Archives
Trending
Support
Login
clear text
XML
Django
JavaScript
MATLAB
C
C++
C#
Python
SQL
Shell
Bash
Markdown
YAML
JSON
HTML
CSS
PHP
Java
Ruby
Go
Rust
Swift
Kotlin
Arduino
TypeScript
Perl
Autohotkey
Lua
SQF
R
Scala
Haskell
Groovy
Dart
Clojure
VB.NET
Objective-C
PowerShell
Bash
CoffeeScript
Verilog
SELECT AKOPF.AUFTRAGSNUMMER AS "Order number", SHIERARCHIE.BEZEICHNUNG AS "Order organisation", SKUNDEN.NAME1 AS "Customer", SUM(ASDGABRECHNUNG.BETRAG) AS "Amount", SUM(ASDGABRECHNUNG.BETRAGSTP) AS "Amount without TAX", SUM(ASDGABRECHNUNG.CALCSTATSTEUERBETRAG) AS "TAX Amount", SUM(ASDGABRECHNUNG.BETRAG) + SUM(ASDGABRECHNUNG.BETRAGSTP) + SUM(ASDGABRECHNUNG.CALCSTATSTEUERBETRAG) AS "Total Income", SWAEHRUNG.ISOWAEHRUNGSCODE AS "Currency" FROM AKOPF LEFT JOIN SHIERARCHIE ON SHIERARCHIE.ID = AKOPF.HIERARCHIE LEFT JOIN ASENDUNG ON ASENDUNG.AKOPFNR = AKOPF.NR LEFT JOIN SKUNDEN ON SKUNDEN.NR = AKOPF.FRACHTAGNR LEFT JOIN ASDGABRECHNUNG ON ASDGABRECHNUNG.ASENDUNGID = ASENDUNG.SENDUNGID LEFT JOIN SWAEHRUNG ON SWAEHRUNG.ID = ASDGABRECHNUNG.WAEHRUNGID WHERE AKOPF.AUFTRAGSNUMMER IN (633168, 633104, 634503) GROUP BY AKOPF.AUFTRAGSNUMMER, SHIERARCHIE.BEZEICHNUNG, SKUNDEN.NAME1, SWAEHRUNG.ISOWAEHRUNGSCODE;
Mark as private (unlisted)
for 30 minutes
for 6 hours
for 1 day
for 1 week
for 1 month
for 1 year
everlasting (like CCCP)
