Can someone explain to me why, when I use the IN join, I am getting an "Unexpected Token: Id" error?
It doesn't always happen, which makes it difficult to tell why it does. Just now, I ran a query to pull a set of Contacts with the Account ID in column E. Next, I wanted to pull some Account information for Accounts in the previous query. A perfect time for "IN," right?
But when I structured the query to find "Account ID IN E:E," I get an error message that says in full:
Salesforce: Query() invalid Range, missing data type, or other error, type is: Account
select id from Account where ID in 'E:E' ^ Error at Row:1:Column:31 Unexpected token: Id
(And to make things more confusing for me, there is nothing in Column 31.)
