You need to sign in to do that
Don't have an account?
Is there a trick to getting parent joins on Task using the WhatId relationship to work?
SELECT a.Id, a.WhoId, a.WhatId, a.Subject, b.Website, b.Id FROM Task a, a.What b
I get the following error:
INVALID_FIELD:
a.ReminderDateTime, a.IsReminderSet, b.Website, b.Id FROM Task a, a.What
^
ERROR at Row:1:Column:342
No such column 'Website' on entity 'Name'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.
The problem seems to be that SOQL can't figure out what to do because the a.What relationship points to a number on entities. Is there some trick I need to do to get this to work?
Thanks,
Eddie