I want to return the account name for each task in a SOQL query, am I correct in saying the relationship is that the Account is the parent object and the Task is the child object? I am not sure who to create my SOQL syntax to carry out this query, here is an example of what I have but I get a fail because the relationship Accounts__r
doesn't seems to exist:
SELECT id, activitydate, accountid, (SELECT Name from Account__r)
FROM task
WHERE isrecurrence = false
ORDER BY activity date ASC