I can't seem to figure this one out. I have 3 objects- Case, Contact, & Purchases (custom).I am writing a SOQL query on Purchases that needs a field from Contact. There is a Master-Detail relationship from Purchases to Case (field name Case__c), and a Lookup Relationship from Case to Contact (field name ContactId). Besides this, Purchases and Case aren't related.
I've been trying the following but I keep getting
Didn't understand relationship 'ContactId__c' in field path. errors, could anyone help me figure out what I'm missing?
[SELECT Case__r.ContactId__r.Fixed_Wholesaling_Channel__c FROM Purchases__c]