SQLize | PHPize | SQLtest

SELECT OBJEKT_KEY, CASE WHEN FELD = 'LTW-BANK-BEZ' THEN STANDARDWERT END AS BEZ CASE WHEN FELD = 'LTW-BANK-WRG' THEN STANDARDWERT END AS WRG CASE WHEN FELD = 'LTW-BANK-BTV' THEN STANDARDWERT END AS BTV CASE WHEN FELD = 'LTW-BANK-BTB' THEN STANDARDWERT END AS BTB CASE WHEN FELD = 'LTW-BANK-ENT' THEN STANDARDWERT END AS ENT CASE WHEN FELD = 'LTW-BANK-BIC' THEN STANDARDWERT END AS BIC CASE WHEN FELD = 'LTW-BANK-PRI' THEN STANDARDWERT END AS PRI CASE WHEN FELD = 'LTW-BANK-BII' THEN STANDARDWERT END AS BII CASE WHEN FELD = 'LTW-BANK-AFA' THEN STANDARDWERT END AS AFA CASE WHEN FELD = 'LTW-BANK-BI1' THEN STANDARDWERT END AS BI1 CASE WHEN FELD = 'LTW-BANK-DZA' THEN STANDARDWERT END AS DZA FROM T_VERTRAG_GP_OBJ WHERE GP_VARIANTE = 'V-AZV-LTW-BK' AND AKTIVITAET_KZ = ' ' AND RANG = 8000 AND OBJEKT_KEY = '0001-01-01-00.00.00.020000' GROUP BY OBJEKT_KEY ) WHERE LEFT(BIC,6) = :BIC-SECHS-CHAR END-EXEC