Integrations and APIs for Service

Get Involved. Join the Conversation.


    chidambaram CT
    Left Join contact with Custom ObjectAnswered
    Topic posted September 23, 2019 by chidambaram CTBronze Trophy: 5,000+ Points, tagged Connect PHP, SOAP 
    15 Views, 1 Comment
    Left Join contact with Custom Object
    Left Join contact with Custom Object

    I have custom object CO.EmploymentDetails with fields Branch,ContactID etc.. This custom object is related to Contact.

    select ID,Contact.CustomFields.c.membership_number,Branch from custom object from Contact C 
    where Emails.EmailList.AddressType.ID=0 and ID=163085

    Can you provide me syntax to get branch?

    Best Comment

    chidambaram CT   

    select I.*, E.* from CO.EmploymentDetails E Join E.contactId I where I.ID = 100