SELECT Name, (SELECT Status,Contact.lastName FROM CampaignMembers where contactid != null), (SELECT Name, accountid FROM Opportunities__r where accountid= :inputAccountId) FROM Campaign where id in(SELECT CampaignId FROM Opportunity where accountid=:inputAccountId)
It will be something similar to the above soql
SELECT CampaignId,Id,Name,OwnerId,Status,Subject FROM ListEmail where campaignid=''
SELECT Name, (SELECT Status,Contact.lastName FROM CampaignMembers where contactid != null), (SELECT Name, accountid FROM Opportunities__r where accountid= :inputAccountId) FROM Campaign where id in(SELECT CampaignId FROM Opportunity where accountid=:inputAccountId)
It will be something similar to the above soql
SELECT CampaignId,Id,Name,OwnerId,Status,Subject FROM ListEmail where campaignid=''
It will be something similar to the above soql
All Answers
It will be something similar to the above soql