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
  )

{{category2 データベース,Postgresql}}