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?