SELECT Id, Name, (SELECT Proveedores__c FROM Proveedores__r), (select name from opportunities where createddate =this_year and stagename='Ganada') FROM Account
where id in (SELECT Cuenta__c FROM Proveedores__c)and id in (select accountid from opportunity where createddate =this_year and stagename='Ganada') But now i'm stuck in how i can show all the Account Name, the Proveedores__c columns and the Opportunity name in a visualforce pageI'll really appreciate your help!!!2 respuestas
