| Subject | Re: [firebird-support] Query and problem with nulls |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2018-01-04T16:18:23Z |
04.01.2018 17:13, Luigi Siciliano luigisic@... [firebird-support] wrote:
with DEPOSITO_ID = 1.
--
WBR, SD.
> if I select between 01/01/2018 and 31/12/2018 I not have results! this because there are no rows in DT between 01/01/2018 and 31/12/2018.That's right. No rows - no result. If you want this result, add into year 2018 a record
with DEPOSITO_ID = 1.
--
WBR, SD.