How hierarchical queries are constructed in MEMSQL

[hanson]

Hi! Please see the answer here:

Hierarchical Queries

We don’t have a built-in feature in our SQL dialect for hierarchical queries yet. I expect us to support recursive common table expressions (CTEs) in the future. For the time being, you can use a stored procedure and do a recursive expansion in a loop. See this page for an example: