+ Start a Discussion

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.