Filter based on presence of many-many related record

In the visual question editor, I have a bunch of joins set up, and I'd like to filter to only show rows that have zero related rows in one of the joined tables.

In SQL terms, I think this would be something like HAVING count( = 0

Is something like that possible?

Hi @tslocke
That would require something like this first: - upvote by clicking :+1: on the first post

Thanks - I'll upvote that.

Is there any way to do it meanwhile? e.g. can I add an SQL WHERE?

All else fails I could create a view, but I'd rather avoid that.

@tslocke The GUI does not allow SQL directly, since then Metabase wouldn't be able to understand it.
You could perhaps use Models: