Hi - relatively new with Looker but old SQL person. This may be a simple question.
I have users that are trying to build a Look that lists out rows from a Master view that lack any activity in a transaction view. To be specific, they have a master view of students (one record per student), and a transaction view of job applications. I have measures in the model to count applications, but because of the way the JOIN works, it is only showing those students with at least one application transaction.
In SQL I would simply “select … from students where studentID NOT in (select studentID from applications)”
How can a user accomplish this in a Look? Thanks!