Previous Topic Next topic Print topic


X108: Field list must be provided when expressions are selected.

The SELECT clause of commands that define views can contain expressions only if the resulting columns are explicitly named. For example:

CREATE VIEW myview(employee, currentpay, afterraise) AS SELECT lname, payrate, payrate*1.10 FROM employee

Because payrate*1.10 is an expression, column names must be provided in the CREATE VIEW clause of the command.

Previous Topic Next topic Print topic