On Mon, Feb 1, 2021 at 6:14 PM Matt Zagrabelny <mzagr...@d.umn.edu> wrote:

> Which field is count(*) counting if it is counting nulls?
>

count(id) excludes from the count rows where the id field is null.  The
presence of a left join in your query is introducing a null here due to
there not being a related field, not because the id value in a table is
actually null.

David J.

Reply via email to