Firebird tells you that it doesn't know what type 0 is. Do these
changes (replacing <INTEGER> with the type of MENGE) and you should be
fine:

CAST(0 AS <INTEGER>) AS "Amin_Total",
CAST(0 AS <INTEGER>) AS "Sand_Total"

Set

--- In firebird-support@yahoogroups.com, "sifi24viper" wrote:
> Hello Folks
>
> Follow i have a UNION-Query that doesn't work!
> Im useing Firebird 1.5.2.4731
>
> SELECT
> MASCHINEN_HEAD.NAME,
> 0 AS "Amin_Total",
> SUM(VERBRAUCH_KSA.MENGE) AS "Sand_Total"
> FROM
> MASCHINEN_HEAD
> INNER JOIN MASCHINEN_ITEM ON (MASCHINEN_HEAD.NR=MASCHINEN_ITEM.NR)
> INNER JOIN SPS_NODE ON (MASCHINEN_ITEM.SPS_NODE=SPS_NODE.SPS_NODE)
> INNER JOIN GET_SPS_NODE(:BENUTZER) ON
> (MASCHINEN_ITEM.SPS_NODE=GET_SPS_NODE.SPS)
> AND (MASCHINEN_ITEM.KSA_MASCHINEN_NR=GET_SPS_NODE.KSA)
> INNER JOIN VERBRAUCH_KSA ON
> (MASCHINEN_ITEM.SPS_NODE=VERBRAUCH_KSA.SPS_NODE)
> AND (MASCHINEN_ITEM.KSA_MASCHINEN_NR=VERBRAUCH_KSA.
KSA_MASCHINEN_NR)
> INNER JOIN KOMPONENTEN ON (VERBRAUCH_KSA.
KOMPONENTEN_NR=KOMPONENTEN.NR)
> WHERE
> (SPS_NODE.MASCHINEN_TYP = 2) AND
> (KOMPONENTEN.TYP = 0) AND
> (VERBRAUCH_KSA.DATUM_ZEIT >= :DateFrom) AND
> (VERBRAUCH_KSA.DATUM_ZEIT <= :DateTo)
> GROUP BY
> MASCHINEN_HEAD.NAME
>
> UNION
>
> SELECT
> MASCHINEN_HEAD.NAME,
> SUM(VERBRAUCH_BGG.MENGE) AS "Amin_Total",
> 0 AS "Sand_Total"
> FROM
> MASCHINEN_HEAD
> INNER JOIN MASCHINEN_ITEM ON (MASCHINEN_HEAD.NR=MASCHINEN_ITEM.NR)
> INNER JOIN SPS_NODE ON (MASCHINEN_ITEM.SPS_NODE=SPS_NODE.SPS_NODE)
> INNER JOIN GET_SPS_NODE(:BENUTZER) ON
> (MASCHINEN_ITEM.SPS_NODE=GET_SPS_NODE.SPS)
> AND (MASCHINEN_ITEM.KSA_MASCHINEN_NR=GET_SPS_NODE.KSA)
> INNER JOIN VERBRAUCH_BGG ON
> (MASCHINEN_ITEM.SPS_NODE=VERBRAUCH_BGG.SPS_NODE)
> WHERE
> (SPS_NODE.MASCHINEN_TYP = 3) AND
> (VERBRAUCH_BGG.DATUM_ZEIT >= :DateFrom) AND
> (VERBRAUCH_BGG.DATUM_ZEIT <= :DateTo)
> GROUP BY
> MASCHINEN_HEAD.NAME
>
> The error message are:
>
> fmSQLEditor.Query:
> Invalid token.Dynamic SQL Error.
> SQL error code = -104.
> Invalid command.
> Data type unknown.
>
>
> But when i try the two SELECT-Statment separatly they work fine!
>
> May somebody have an idea!
>
> Gregor