How would I write an expression for a slice to return data where no records are found in a child table?
Example:
I have two tables Personas and Notas.
Multiple Notas can be associated to a Person.
But a Person may not have any Notas.
In SQL, I would write it this way:
Select *
from Personas left outer join Notas on Personas.Persona ID = Notas.Persona ID
where Notas.Persona ID is null
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |