Nested SELECTs aren't supported. Query over Query aren't allowed more then 3 times. What shall we do?
Dear Zoho Reports Team,
Thank you for the great product!
Unfortunately, your SQL dialect lacks one of the most important things: nested SELECTs. When i realized that i was disappointed.
Then i found a workaround: make a SELECT and save it as query table, then make a new query table and select from the first query table.
Everything was going correct until i got an error:
"The above query cannot be saved, a maximum of 3 levels of Query over Query tables only allowed."
That's a pity. That's frustrating.
I can't continue creating my complex report/generator.
Is it possible to increase the numer of allowed nested queries? We can buy that if it's possible.
Thank you.