Version 1.5 SELECT * FROM ScaleSummary ( ON ( SELECT * FROM ScaleMap ( ... ) AS alias_1 ) PARTITION BY 1 ) AS alias_2;