Can we query or make report on 3 objects if one of them is lookup for other 2 but they are not related to each other?
Suppose 3 objects are A, B, and C.
A is lookup on B and also on C. This means we can query like
Select id from B__c where A__r.name and A__r.id....
Similarly Select id from C__c where A__r.name and A__r.id....
Can we somehow query all 3 in one or extract fields for all 3 in one report?