bankenspiegel.sql 417 B

123456789101112
  1. select T1."ID" as "Id",
  2. T1."Betrieb Nr" as "Betrieb Nr",
  3. T1."Bank" as "Bank",
  4. T1."Stufe 1" as "Stufe 1",
  5. T1."Konto Nr" as "Konto Nr",
  6. T1."Bezeichnung" as "Bezeichnung",
  7. T1."Bemerkung" as "Bemerkung",
  8. T1."Besicherung" as "Besicherung",
  9. T1."Kreditlinie detailliert" as "Kreditlinie Detailliert",
  10. T1."Ist" * -1 as "Ist",
  11. 'LZ ' + T1."Laufzeit" as "Laufzeit"
  12. from "Bankenspiegel" T1