Sign Up ›
  • Harikishore Bandi
  • NEWBIE
  • 0 Points
  • Member since 2019
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
3 replies

How to retrive Opportunity name and Account name where Opportunities are related with Accounts .

Hello:
SELECT Name FROM Opportunity WHERE AccountId IN (SELECT Id FROM Account);

Why its throwing error while I'm including field Account in below query when i was trying to retrive Opportunity name and Account name.

SELECT Name, Account FROM Opportunity WHERE AccountId IN (SELECT Id FROM Account);

This column details are related to Opportunity name.I want to retrieve related Account names for that oppurtunity name.
3 replies

How to retrive Opportunity name and Account name where Opportunities are related with Accounts .

Hello:
SELECT Name FROM Opportunity WHERE AccountId IN (SELECT Id FROM Account);

Why its throwing error while I'm including field Account in below query when i was trying to retrive Opportunity name and Account name.

SELECT Name, Account FROM Opportunity WHERE AccountId IN (SELECT Id FROM Account);

This column details are related to Opportunity name.I want to retrieve related Account names for that oppurtunity name.