This repository was archived by the owner on Oct 16, 2021. It is now read-only.
This repository was archived by the owner on Oct 16, 2021. It is now read-only.
Open
Description
Summary
MySQL 8.0 CTE:
WITH
cte1 AS (SELECT a, b FROM table1),
cte2 AS (SELECT c, d FROM table2)
SELECT b, d FROM cte1 JOIN cte2
WHERE cte1.a = cte2.c;
https://dev.mysql.com/doc/refman/8.0/en/with.html#common-table-expressions