I'm trying to use a WITH clause as outlined here:
https://dev.mysql.com/doc/refman/8.0/en/with.html
in one of my MySQL dataflows.
But I keep getting this error:
"The database reported a syntax error. You have an error in your SQL syntax"
My (very simple) code is:
WITH test AS (SELECT`EmaiName` FROM transform_data_2)
SELECT `EmaiName` FROM test
As far as I can tell that should be correct - is this just a matter of Domo not supporting WITH?
Not a big deal either way, but it would be nice to know.