SQL Query - Left Join (not able to save query)

SQL Query - Left Join (not able to save query)

Does Zoho Reports support LEFT JOIN query?

SELECT column_name(s)
FROM table_name1
LEFT JOIN table_name2
ON table_name1.column_name=table_name2.column_name

I have created a LEFT JOIN query and when I select "execute query" .....the preview results look correct.....however when I go to SAVE the query....I get the following error.

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.







THANK YOU FOR ANY HELP.