WITH A AS (
 WITH A1 AS (
 SELECT *
 FROM aaa1226.123
 LIMIT 1
 )
 SELECT *
 FROM A1
 ),
 B AS (
 SELECT *
 FROM aaa1226.123
 LIMIT 1
 )
SELECT *
FROM A, B
---------------------------
WITH A AS (
		WITH A1 AS (
				SELECT *
				FROM aaa1226.123
				LIMIT 1
			)
		SELECT *
		FROM A1
	), 
	B AS (
		SELECT *
		FROM aaa1226.123
		LIMIT 1
	)
SELECT *
FROM A, B