I'm trying to get a phone number from an Account with a completed Event in SOQL. Here is my query
select Phone from Account where Name in (select School_Name__c from Event where Visit_Status__c = 'Completed')
I get an error that says
Entity 'Event' is not supported for semi join inner selects
Is this possible to do in one SOQL query?