Answers for "can you use a where clause for a child query"

SQL
2

can you use a where clause for a child query

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')
Posted by: Guest on June-05-2020

Code answers related to "can you use a where clause for a child query"

Code answers related to "SQL"

Browse Popular Code Answers by Language