The rows that match a where-clause tree (see ConditionNode): only those for which the whole tree is true, so
not (n = 5) returns the same rows as n != 5 (neither returns a row where n is null or missing). Every row when
there is no where clause.
With a joinEntity (the tree uses its fields, see conditionEntities), it's SQL's inner join, evaluated per pair: each
row keeps the joined rows for which the tree is true with that pair, and a row left with none is dropped.
The rows that match a where-clause tree (see ConditionNode): only those for which the whole tree is true, so
not (n = 5)returns the same rows asn != 5(neither returns a row where n is null or missing). Every row when there is no where clause.With a joinEntity (the tree uses its fields, see conditionEntities), it's SQL's inner join, evaluated per pair: each row keeps the joined rows for which the tree is true with that pair, and a row left with none is dropped.