Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m confused

Relationship Opportunities is not valid on a valid SOQL query

Query works in Force.com explorer but dbamp gives me "Relationship Opportunities is not valid" error.
SELECT * from openquery(SFDC_PROD,'
SELECT ID, email, (SELECT CaseNumber FROM Cases), (SELECT ID FROM Opportunities)
FROM Contact')
1 person has
this problem
+1
Reply