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 vote258 views1 answer
Grepper sql workbench download
SQL
0 vote317 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
1 vote259 views1 answer
Sql server get users
SQL
24 votes283 views6 answers
Alter table name sql
SQL
4 votes263 views3 answers
How to describe a table in sqlite3
SQL
1 vote275 views1 answer
Round function in sql oracle
SQL
27 votes276 views3 answers
Mysql show tables in database
SQL
0 vote271 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
15 votes264 views2 answers
Select Options
SQL
15 votes256 views2 answers
How to know the username of postgresql
SQL