SQLのwith句

with句は、入れ子、連続ができる。

連続

with TableA  as (
  select * from A
), TableB as (
  select * from B
)

入れ子

with TableA as {
  with Table B as (
    select * from B
  )
  select * from A left join B on A.id = B.id
 )