i am at a wits end, any help greatly appreciated
I have a child object named acf_address__c , that is a child of the contact object
the child relationship name on the acf_address__c is called Constituent_Addresses
I run the following query, and always get the contact id, name and null for my child subquery, i believe i have it correct, and know that data exists for both the parent and the child of this contact Id
select id , name
,(SELECT Name, MailingStreet__c FROM Constituent_Addresses__r)
from contact
WHERE Id = '0030R00000OsKCjQAN';
( i did not name any objects, dealing with aftermath of contracted work)