Advance queries - With clause

Hi 

Just wondering if advanced queries support the 'with' clause

eg

WITH cte1 AS (SELECT a, b FROM table1),

cte2 AS (SELECT c, d FROM table2)

SELECT b, d FROM cte1 JOIN cte2

WHERE cte1.a = cte2.c;