How can I use SOQL to join the AccountShare, Account & User objects to fetch matching data?
Here are my attempts so far
select id, accountid, accountaccesslevel, rowcause from accountshare where userorgroupid in (select id from user where name = 'john') and accountid in (select id from account where recordtype.name = 'foo')
This works fine.
How can I do a traditional (inner) join by moving the
Accountobjects into the
FROMclause so I can retrieve information from them? I tried using the obvious SQL syntax but got a "Unknown error parsing query" in the Developer console.
How can I do the same thing using the REST API?