Thread Details

When running a query which includes a sub-query, I'm not seeing the results from the sub-query although the rest of the query is returning data

So, for example, the following query is only displaying a single column of IDs

Is there any way to get sub-queries to return data?

SELECT

ID,
(SELECT ID FROM Contacts)

FROM 

Account

LIMIT 10

Thanks,

Frazer

Hi Frazer,

I ran the query in one of our orgs and can see the sub-query results. Data from a sub-query is returned in a grid subordinate to the row that owns it when the Render Style is set to Hierarchical (the default). You should see a chevron next to each row number that lets you expand the view to see the sub-query results for that row. Alternatively, you can change the Render Style to Flat, which will reformat the result into a traditional relational result set. 

Thanks for clarifying the two ways to render the subquery results