Get parent records with 0 children in SOQL February 16, 2016June 9, 2022InfallibleTechie Admin Sample Query: SELECT Id, Name FROM Account WHERE Id NOT IN (SELECT AccountId FROM Contact) Cheers!!!