In salesforce> I have one checkbox on contact object.
I want to get all accounts and it's all contacts if that checkbox on contacts is checked;
Select Name, (Select Name, checkbox_c From contacts where checkbox_c =true) From Account
If we use the above query then it will return the account with no contacts also. But I don't need account record if this don't have any contact with checkbox__c checked.