with as才知道

https://www.cnblogs.com/shoshana-kong/p/16580840.html

with name1 as (
    select 脚本1   
),
name2 as (
    select 脚本2
)

select *
  from name1 a
innert join name2 b on a.id = b.id

　　

还能这么玩，临时分析数据不用写代码了