Here is my SOQL query below in Alteryx application where I have to extract the Id from Contact object which has two level sub-selects. I could only make the SOQL query to work for 1 level of subselect but not more.
Are there any workarounds for this? It would be of great help if someone can edit my code to make it work.
Select Id from Contact c Where c.Id in (SELECT contact__c FROM VIN__c v where v.Id in (SELECT vin__c FROM Mileage_Reading__c WHERE CreatedDate >= 2020-06-01T00:00:00Z AND CreatedDate < 2020-07-01T00:00:00Z))