function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
RCJesseRCJesse 

joining tables in SOQL

We are moving away from using the Contract object to a new custom object Implementations. Contracts up until this point have notes and events tied to them but I need to migrate them to be tied to the Implementations.

 

How can i write a query that can find all the notes tied to a Contract and the Implementation Id it should be tied to? The notes can be traced back via the Contract: Account->Contract->Notes and the Implementation is a direct lookup to the Account: Account->Implementation.

 

Thanks.