title: Filtering Opportunities by Tasks using SOQL?
body: <p>I'd like to pull all Opportunity IDs that have a task associated with a certain person. </p>
  
  <p>I've tried the following</p>
  
  <p>Select ID from Opportunity where AccountID IN (Select AccountID From TASK WHERE CreatedBy.Name='Person' OR LastModifiedBy.Name='Person' )</p>
  
  <p>But I get the following error 
  ERROR at Row:1:Column:80 Entity 'TASK' is not supported for semi join inner selects"</p>
  
  <p>Is there any work around to this?</p>