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')

Source: salesforce.stackexchange.com

Similar codes

0 vote131 views1 answer
Python list from sql
SQL
0 vote171 views1 answer
AddEntityFrameworkSqlite
SQL
0 vote118 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
9 votes127 views3 answers
Sql delete where in
SQL
0 vote130 views1 answer
Supprimer les valeur d'une table mysql
SQL
10 votes121 views2 answers
Linux command line import mysql database
SQL
7 votes128 views1 answer
Minecraft forge server host
SQL
4 votes134 views2 answers
Sql offset
SQL
2 votes118 views1 answer
Postgresql left join distinct on
SQL
0 vote130 views1 answer
Oracle sql procedure return value
SQL