Nested Query in SOQL
02:24 28 Feb 2022

Can someone please help me generate SOQL for the below query. Getting this error - Nesting of semi join sub-selects is not supported

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) > 2020 and Status_vod__c = 'Paid_in_Full_vod'))
salesforce soql cloveretl