Getting error when using the alias name for Tablename

sudharshan

When i use the following query i am getting the error. At the same time if
i remove the table alias name i am not getting any error. Please advice

SELECT
CLASSICMODELS.EMPLOYEES.EMPLOYEENUMBER,
CLASSICMODELS.EMPLOYEES.LASTNAME || ', ' || CLASSICMODELS.EMPLOYEES.FIRSTNAME EmployeeName
FROM
CLASSICMODELS.EMPLOYEES Employee

mwilliams

Hi sudharshan,

Try this:

SELECT
CLASSICMODELS.EMPLOYEES.EMPLOYEENUMBER,
(CLASSICMODELS.EMPLOYEES.LASTNAME || ', ' || CLASSICMODELS.EMPLOYEES.FIRSTNAME) EmployeeName
FROM
CLASSICMODELS.EMPLOYEES Employee