WITH Table AS () SELECT

WITH table1 AS ( SUB쿼리 )
      ,table2 AS ( SUB쿼리 )
SELECT a.*, b.*
FROM table1 a, table2 b 
where a.idx = b.idx
;