parent to child query in salesforce after where clause code example
Example: where clause for child record apex
Select C1, C2 from A
where
ID in (Select ParentId from B where Status__c='Completed')
and
Id NOT IN (Select ParentId from Opportunity where Status__c <> 'Completed')