Salesforce Developer Community

Hi,

I'm having trouble joining 2 tables. I want to get the Account details from the opportunity.

My Query:

$query = "SELECT Opportunity.Id, Opportunity.Name FROM Opportunity, Account WHERE Opportunity.AccountId = Account.Id";

Result:

MALFORMED_QUERY: WHERE Opportunity.AccountId = Account.Id ^ ERROR at Row:1:Column:96 unexpected token: Account.Id