MindsDB supports standard SQL syntax, including Common Table Expressions (CTEs).CTEs are used to create temporary, named result sets that simplify complex queries, enhance readability, and allow for modular query design by breaking down large queries into manageable parts.
Copy
Ask AI
WITH table_name1 AS ( SELECT columns FROM table1 t1 JOIN table2 t2 ON t1.col = t2.col),table_name2 AS ( SELECT columns FROM table1 t1 JOIN table2 t2 ON t1.col = t2.col)SELECT columnsFROM table_name1 t1JOIN table_name2 t2ON t1.col - t2.col;