Adding variables

[Gideon Engelbrecht]

Hi all

I am trying to add two variables together, but am getting a zero value.

set @UitvoerRooiwyn = (select sum(Liter) from verkope WHERE InUit = 'EXPORT' AND TipeProduk = 'Wyn' AND Kleur = 'Rooi');
set @UitvoerWitwyn = (select sum(Liter) from verkope WHERE InUit = 'EXPORT' AND TipeProduk = 'Wyn' AND Kleur = 'Wit');
set @HaweRooiwynBinnelands = (select sum(LiterPerPad) from ccc_verspreiding WhERE Kommoditeit = 'Wyn(rooi)' AND RoetePerPad = 'Hawe');
set @HaweWitwynBinnelands = (select sum(LiterPerPad) from ccc_verspreiding WhERE Kommoditeit = 'Wyn(Wit)' AND RoetePerPad = 'Hawe');
set @TotaleRooiwynHawe = @HaweRooiwynBinnelands + @UitvoerRooiwyn;

select @UitvoerRooiwyn,@HaweRooiwynBinnelands,@TotaleRooiwynHawe ;

My issue lies here : set @TotaleRooiwynHawe = @HaweRooiwynBinnelands + @UitvoerRooiwyn;


@TotaleRooiwynHawe gives a zero result. Though @UitvoerRooiwyn is not zero and @HaweRooiwynBinnelands is zero.

What am I missing ?

Regards