Do MySQL dataflows support the use of the WITH clause?
I'm trying to use a WITH clause as outlined here:
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.