So I have a custom object standard controller and I want to auto-populate a field on a form from the users account record.
In preparation to build my controller I need a valid SOQL statement and I'm getting nested semi-join sub selects error on the Workbench.
I'm getting errors on the SOQL query:
select agency_acronym__C from account
where id in (SELECT AccountId FROM Contact
where id in (SELECT ContactId FROM User
where id in (SELECT OwnerId FROM Application__c)))
if this where in SQL Syntax I'd just use joins. I'm new to SOQL
select agency_acronym__c from
account inner join contact on account.accountID = contact.accountID
inner join user on contact.contactid = user.contactid
inner join application__c on user.id = application__c.ownerid