first time I have needed to do a join in soql and I'm lost.
in MySQL it would be
Select AccountId, Account.ParentId, Account.Dealer_ID__c, User.Name FROM Account LEFT JOIN User on (account.OwnerId = User.id)
but I can't make it work salesforce, the closest I have that works is:
SELECT Name FROM User Where Id IN (SELECT OwnerId FROM Account where Dealer_ID__c = '04932')
but that works only for a single id, not for getting all rows from Account.