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
mromani1mromani1 

Multi Table Join

Is there a way to do multi table  joins?

 

If so, how?

 

Thanks

JimRaeJimRae

Depends on the relationships between the objects. If they are related, you can add all of the joins as relationships or subqueries depending on which way th relationship goes from your primary table.

Otherwise, you can use a wrapper class to merge your results together into a "temporary object" of sorts.

 

Here is a basic article on wrapper classes, and I am sure you can search the forums for more detailed examples:

 

wiki.developerforce.com/index.php/Wrapper_Class