Share
ReportHow to join more than 10 tables in DB
*This post is locked for comments
You’re offline. This is a read only version of the page.
5,005
How to join more than 10 tables in DB
*This post is locked for comments
You can use Filtered views where you get lookups names and options sets are already retrieved
then views with entity name where only lookup names retrived
Then there is base tables where you have to perform joins normaly
Refer below sql for joins, you can select other fields for related entities as well using prefix used in join statement
SELECT a.new_name,b.new_name,b.new_otherfield,c.new_name,d.new_name,e.new_name,f.new_name new_aBase a join new_bBase b on a.new_aid = b.new_aid join new_cBase c on a.new_aid = c.new_aid join new_dBase d on a.new_aid = d.new_aid join new_eBase e on a.new_aid = e.new_aid join new_fBase f on a.new_aid = f.new_aid join new_gBase g on a.new_aid = g.new_aid
and so on..
with more than 10 inner join statements.
If you are talking about CRM OnPremise than you can use the Filtered Views (like SELECT * FROM FilteredAccount) and after write the SQL statements as any other DB
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (