Salesforce SOQL query to find an opportunity, given its parent account id?

Question

How can you write a SOQL (Salesforce query language) query to find an opportunity, given its parent account's account id?

I want to do something like this (doesn't work though):

SELECT Id, Name FROM Opportunity WHERE AccountId = '003D000000f0gfH'

score 6 · Accepted Answer · answered May 18 '12 at 01:42

6

Your query is fine, but you don't have an AccountId, 003 prefixed ids are for contacts.

answered May 18 '12 at 01:42

superfell

1 Answers1