相当于建立了一张temporary table,暂时保存某个查询的结果,通过SELECT调用
WITH
subtable1 AS (SELECT...),
subtable2 AS (SELECT...),
subtable3 AS (SELECT...)
SELECT
subtable1. *,
subtable2. *,
subtable3. *
FROM subtable1
JOIN subtable2 ON...
JOIN subtable3 ON...