I am totally new to SalesForce ... I literally just started playing with it 2 days ago. I signed up for a few classes (for next month) in the meanwhile I started playing with queries and I came across a situation that I can't seem to find a solution to: inner joins in SOQL.

Here's the scenario. 

I have this:

and I have this:

and I want to use this:
 

SELECT *
FROM Account AS ato, AccountPartner AS ap, Account AS afrom
WHERE ap.AccountToID = ato.AccountID
and ap.AccountFromID = afrom.AccountID;

To get this:

How do I do it in SOQL?

PS: I dumped data in MS Access and ran the query I just pasted above ... That's where the join result set comes from.

Thank you!!