Hi Mike, As a work around if you use Class name instead of thing.thingStats it will work properly. eg. select thing from Thing thing left join ThingStats thingStats where thingStats is null or thingStats.rejectedCount = 0;