I am still new to Salesforce and haven't quite wrapped my head around SOQL queries yet. I still tend to think more in terms of SQL. Anyway, I am trying to write a statement that gives me all "Call Tasks" that are attached to all Opportunities of an Account.
SELECT Id, (SELECT Id FROM Opporunity, (SELECT Id FROM Task WHERE Type="Call") FROM Account
Any ideas in how to make this work? Tia.