I need to combine these 2 queries so that I get the Case Members and Case details in one result. There are no custom fields/objects.
Both queries run independently but when I try the subquery/relationship options, I get an error message:
select id, parentid, member.name,teamrole.name from caseteammember
select casenumber, subject, status from case
Select id, parentid, member.name,teamrole.name,(select casenumber, subject, status from cases) from caseteammember
ERROR at Row:1:Column:89 Didn't understand relationship 'cases' in FROM part of query call. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.member.name,teamrole.name,(select casenumber, subject, status from cases) from caseteammember