On 12-7-2014 17:07, Piotr Olszewski [email protected] [firebird-support] wrote: >> On 12-7-2014 15:57, Łukasz Bączek [email protected] [firebird-support] wrote: >> > Hello, >> > I have a SQL query: >> > >> > >> > SELECT >> > CASE WHEN umowy.numer_umowy IS NULL THEN 0 END AS numer_umowy >> > FROM umowy >> > WHERE umowy.data_podpisania IS NOT NULL AND umowy.id_wnioski IN >> > (SELECT CASE WHEN wnioski.id_wnioski IS NULL THEN 0 END AS id_wnioski >> > FROM wnioski >> > LEFT JOIN kategorie_wnioskow ON >> > kategorie_wnioskow.id_kategorie_wnioskow=wnioski.id_kategorie_wnioskow >> > WHERE kategorie_wnioskow.id_kategorie_wnioskow_typ=1) AND umowy.rok=2014 >> > >> > How do I stop if "NUMER_UMOWY" is NULL is returned to "0" and not null >> >> I have read this question multiple times, but I don't understand what >> you mean. Could you give an example of data and the result you want to >> have? >> > After this query I have the result: > > "UMOWY.NUMER_UMOWY" = NULL > > It needs to > > "UMOWY.NUMER_UMOWY" = 0
Do you actually get any rows back? Mark -- Mark Rotteveel
