ROQL child to parent to child

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.