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.