ust i am wondering why like this , and i know relationships are crazy many times in SFDC
I have a query as below and getting results :
select id,name,(select id,name from Batches__r)from Faces__c where Account__r.name='A Place'
and i am not getting the value for this query
select id,name,(select id,name from faces__r),(select id,name from Batches__r) from Account where name='A Place'
Relationships goes like this : Faces have master detail relationship with Account , Batches have lookup relationship with Account and Batches have master detail with Faces again
So i wanted to know exact reason why this is happening.
Thanks in advance for your help.
Thanks & Regards sfdev