There are a few different variations of SQL. ANSI SQL, MS SQL, MySQL, PostgreSQL, etc.

They are all very similar but might have a few differences in syntax. Like Date() vs GETDATE()

You probably need to modify it slightly to use with Zoho.

Here's a quick example from chatGPT.
MS Access SQL
SELECT IIf([Amount] > 1000, "High", "Low") AS Category
FROM Sales;

ANSI SQL for Zoho Compatibility
SELECT CASE WHEN Amount > 1000 THEN 'High' ELSE 'Low' END AS Category
FROM Sales;

Supported SQL
https://www.zoho.com/analytics/api/v1/zoho-cloudsql/supported-sql.html

Get Perplexity or Grok to do the conversion for you :-)

Thanks for the info.

Thanks Alex, I made some progress tweaking the Access SQL for Zoho.

Martin Good to know. I also found this resource. https://www.jooq.org/translate/

David I've never used this site before, great find.