Find all Account records which have an associated Opportunity which has been lost

select id, name ,(select id from opportunities where StageName='Closed Won') from account

You must be logged in to post a comment.