Multiple Joins in SQL Query Table

Hi!

I would like to ask, how many times can you use join?

I have merged 4 tables and it successfully executed the query. However, upon saving the query table, it generates an error:

Error Details:

Execution of the specified query was aborted, as processing time exceeded the allowed time limit. This is done to avoid any performance impact on the Zoho Reports service.

Some tips to avoid this:

Verify whether you have unnecessary table joins in the query Or could you simplify it further

Verify whether you have redundant "Order By" clause or any "Order By" over a general plain text column

For further assistance contact us at support@zohoreports.com with your SQL query.

This is how I joined a table:

Select " QueryTable1".*, " QueryTable2".* from " QueryTable1" inner join " QueryTable2" on " QueryTable1"." Code" = " QueryTable2"." Code"

QueryTable1 and QueryTable2 are query tables, each with 2 different tables joined. Therefore, I have a total of 4 different tables.

btw i have more than a hundred thousand records in QueryTable1 and less than hundred thousand records on QueryTable2 so I understand why it times out. But, may I know the limit of the records/tables that can be joined?

Please assist me on this.

Thanks!