How would I write an expression for a slice t...

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

0 9 384
9 REPLIES 9
Top Labels in this Space