You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ROQL child to parent to child

Accepted answer
19
Views
4
Comments
edited Mar 15, 2017 10:58PM in Integrations and APIs 4 comments

Content

I am trying to figure out how to use ROQL (in c#, soap v1.3) to join from a child to a parent to a child.  These are all custom tables.

I have a child table called site2opp that joins to a parent table site (there are more than one parent tables here).  This works fine.

Select A.Site.* FROM site2opp A

Note:  I used * to abbreviate here and not list out the fields.  I do not use * in the actual query.

when I try to join to the child table OrderHistory on Site I run into an error.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!