1

Topic: Behavior LIST is not clear

SELECT
...
list (distinct cbd.date_receipt, ', ') date_receipt
FROM
wp_supply_cardboard_itm cbd
LEFT JOIN wp_supply_cardboard_woff cbd_woff ON (cbd_woff.supply_cardboard_itm = cbd.id) and (cbd_woff.stock = 2)
group by
...
having sum (cbd_woff.amount) <> 0

In LIST all dates, even with zero residuals (such feeling that the condition in having does not operate on LIST) get

2

Re: Behavior LIST is not clear

mkr;
Also should not operate. having filters the data already after aggregation

3

Re: Behavior LIST is not clear

Simonov Denis;
Thanks, request I will alter