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