Is there a max nbr of tables I can join in a rpt?

[jowilliams]

Is there a maximum number of tables that I can join for use in a report?
I have an existing report joining 15 tables and need to add another 3. I can successfully add the tables via Visual Linking but when I then preview the SQL syntax, the new tables don't show up. The fields do, however show up in the formula editing window so I can add the columns I need to my formula - but when I run the report I'm getting an "invalid column" error.

I'll likely get around this by implementing a view and reference it in the rpt - but I'm curious if there's a cap on the nbr of joins...

Jo

 

[KamalKhalil]

Several references stated that 16 Tables is the Max.
You will get an error after that. Kamal Khalil
Sr. Client Technical Analyst
kkhalil@Houston.ds.adp.com