You need to sign in to do that
Don't have an account?
Join query doesn't work
Hi,
I have this query and tested in Setup/System Log/ Execute Apex and it works fine.
SELECT Account.Name, (SELECT Contact.LastName FROM Account.Contacts) FROM Account
However, I plugged this query in my app and it doesn't work. and it give me this error.
INVALID_TYPE: sObject type 'account.contacts)' is not supported. If you are attempting to use a custom object, be sure to append the '__c' after the entity name. Please reference your WSDL or the describe call for the appropriate names.
If I remove (SELECT Contact.LastName FROM Account.Contacts), then it works fine.
Any advice?
Thanks,
Any workaround for this?
If I'm not mastaken, you can only query one table at a time.
Being that you must "Create" and account (make a connection with a table. One table)
So, what I have done is to query one table. Get the return data and use it to query the next table.
Ira
Hi Steve,
Have you tried with a query like this one?
Please let me know if this query heps.
Bruno