Textfeld einbauen

[Heinzi79]

Hallo, weis jemand wie man der Berechnung ein Texfeld einbauen kann,
unter FROM "viw_Spielplan.

SELECT "a"."Verein", SUM("Spiele") AS "Spiele", SUM("Siege") AS "Siege", SUM("Unentschieden") AS "Unentschieden", SUM("Verloren") AS "Verloren", SUM("Tore") AS "Tore", SUM("Gegentore") AS "Gegentore", SUM("Punkte") AS "Punkte" FROM
(SELECT "HVerein" AS "Verein", COUNT("Datum") AS "Spiele", COUNT("HSieg") AS "Siege", COUNT("HUnentschieden") AS "Unentschieden", COUNT("HVerloren") AS "Verloren", SUM("HTore") AS "Tore", SUM("ATore") AS "Gegentore", SUM("HPunkte") AS "Punkte" FROM "viw_Spielplan" GROUP BY "HVerein"
UNION ALL
SELECT "AVerein" AS "Verein", COUNT("Datum") AS "Spiele", COUNT("ASieg") AS "Siege", COUNT("AUnentschieden") AS "Unentschieden", COUNT("AVerloren") AS "Verloren", SUM("ATore") AS "Tore", SUM("HTore") AS "Gegentore", SUM("APunkte") AS "Punkte" FROM "viw_Spielplan" GROUP BY "AVerein") AS "a"
GROUP BY "a"."Verein"

MfG Renne

 

[ukulele]

Vermutlich

SELECT 'Text' AS Textspalte