Is there a way to apply outer or inner join kind of query in Salesforce operation? For example i want to pull Prospect Opty's as well and join that with my main Quote object.
Right now i have selected Opty as Parent object and so all the Opty's that are associatd with quote are getting populated. Now the requirement is to load those Opty's as well which does not have a Quote associated with them.
Is there a way to achieve this or i will just have to append the Prospect Opty's later into the target once everything is loaded?