can you use a where clause for a child query

Solutions on MaxInterview for can you use a where clause for a child query by the best coders in the world

Search
showing results for - "can you use a where clause for a child query"
Jaxon
11 Jan 2017
1Select C1, C2 from A 
2where 
3ID in (Select ParentId from B where Status__c='Completed') 
4and 
5Id NOT IN (Select ParentId from Opportunity where Status__c <> 'Completed')
6
source
similar questions
sql nested selecthow to get parent and child record in single query using sqlnested query sqlhaving clause vs where clause sqlsql query use select name inside where clausewhere clause vs having sqldifference between where and having clausesql server xquery count child nodessql select inside select sub query
queries leading to this page
where clause in parent to child soqlparent to child query in salesforce after where clausewhere clause for child record apexapex query child recordssoql where caluse on childquery on parent and child condition soqlcan you use a where clause for a child query