使用半连接

选择所有在其下具有未知机会记录的帐户

SELECT Id, Name FROM Account WHERE AccountId IN 
    (SELECT Id FROM Opportunity WHERE IsClosed = false)