Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
mahimahi 

how to select fields in relationship query

hi all,
 
i have written a query::
 
campaign[ ] camp=[select cg.name, (select ld.count() from leads ld where rating='hot') from campaign cg where name='test_mahesh' limit 1];
 
i am not sure whether its right or not.
 
if right then how can i access count() field inside this relationship query. please help me out.
 
thanks,
 
mahi
SuperfellSuperfell
You can't use count in an aggregate child query.
mahimahi

thanks a lot sir!!

now if i write

campaign[ ] camp=[select cg.name, (select ld.name from leads ld where rating='hot') from campaign cg where name='test_mahesh' limit 1];

 how should I access name fields for campaign and leads.

thanks,

mahi