Integrations and APIs for Service

Get Involved. Join the Conversation.

Topic

    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
    Title:
    Left Join contact with Custom Object
    Summary:
    Left Join contact with Custom Object
    Content:

    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

    https://cloudcustomerconnect.oracle.com/posts/41398ca396   

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

    Comment