I'm trying to use SOQL 'relationships' between two tables.
I follow this example and it works fine:
SELECT Account.Name, (SELECT Contact.Name FROM contacts) FROM Account
I attempt what I think is equivalent on our Org:
SELECT Case.Postcode_and_number__c, (SELECT SocialPersona.Id FROM SocialPersonas) FROM Case
But I get:
INVALID_TYPE: (SELECT SocialPersona.Id FROM SocialPersonas) FROM Case ^ ERROR at Row:1:Column:67 Didn't understand relationship 'SocialPersonas' in FROM part of query call. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
Could someone please tell me what I'm missing here? Thank you.
SELECT SocialPersona.Id FROM SocialPersonas__r
. Try appending the '__r'