+ Start a Discussion
SArunSArun 

Help on writing SOQL

 

Can some one help me to write SOQL to query contact details of account related to opportunity? the below gets me the account details but i need the contact info too. 

 

SELECT
Name,
StageName,
Amount,
Opportunity.Account.Name
FROM
Opportunity

 

Rick-ProfaceRick-Proface

Hello SArun,

 

I am new too and this program helped me learn a little more about SOQL. you can build queries on the fly and see if your getting the intended result. Then copy and past the SOQL into your code.

 

The URL is  :   http://wiki.developerforce.com/index.php/Apex_Explorer

 

Hope this helps.

 

Rick