title: Nested Query in SOQL
body: <p>Can someone please help me generate SOQL for the below query.
  Getting this error - Nesting of semi join sub-selects is not supported</p>
  <pre><code>SELECT External_ID_vod__c, FirstName, LastName, Middle_vod__c  
  FROM Account
  where Id IN (select Account_vod__c from EM_Attendee_vod__c WHERE Id IN (SELECT  Incurred_Expense_Attendee_vod__c
  FROM Expense_Header_vod__c 
  where CALENDAR_YEAR(CreatedDate) &gt; 2020 and Status_vod__c = 'Paid_in_Full_vod'))
  </code></pre>