-153 THE STATEMENT IS INVALID BECAUSE THE VIEW OR TABLE DEFINITION DOES NOT INCLUDE A UNIQUE NAME FOR EACH COLUMN
Explanation
You must specify a list of column names if the result table of the fullselect that is specified in the CREATE VIEW, CREATE TABLE, or DECLARE GLOBAL TEMPORARY TABLE statement has duplicate column names or an unnamed column (a column from a constant, function, or expression).
System action
The statement cannot be processed. The specified view or table was not created, or the declared temporary table was not declared.
Programmer response
Correct the statement by providing a list of names for the columns of the view or table.
SQLSTATE
42908