# E051-09: Rename columns in the FROM clause

statement ok
CREATE TABLE TABLE_E051_09_01_01 ( ID INT PRIMARY KEY, A INT, B INT );

query III
SELECT ALL MYTEMP . X , Y, Z FROM TABLE_E051_09_01_01 AS MYTEMP ( X, Y, Z )

statement ok
CREATE TABLE TABLE_E051_09_01_02 ( ID INT PRIMARY KEY, A INT, B INT );

query III
SELECT DISTINCT MYTEMP . X , Y, Z FROM TABLE_E051_09_01_02 AS MYTEMP ( X, Y, Z )

statement ok
CREATE TABLE TABLE_E051_09_01_03 ( ID INT PRIMARY KEY, A INT, B INT );

query III
SELECT MYTEMP . X , Y, Z FROM TABLE_E051_09_01_03 AS MYTEMP ( X, Y, Z )
