Select all names where none of that names entries are approved

[Subterfugue]

I have a table that contains an name field and an approved field. However multiple entries can have the same name. I have been trying to write a query that finds all unique names and decides if it has no approved entries

I feel like I need to use a join but I can only really join it with itself. Is there a function that does this that I'm just not finding? Or do i need to use some weird kind of join to make this work.

Continue reading...