Qfyilyi

I am asked to do the following:

Create a new table, named sec0902_employees, that adds two new columns to the l_employees table.

Create the new columns by using the following row functions:

Column Name: full_name

Access: first_name & ' ' & last_name

Column Name: new_credit_limit

Access: credit_limit + 10.00

Here is my code:

select l_employees.*, 

first_name & ‘ ‘ & last_name as full_name,

credit_limit as new_credit_limit + 10.00

into sec0902_employees

from l_employees;

This is the error:

Syntax error (missing operator) in query expression ‘first_name & ‘ ‘ & last_name as full_name’

Here is a screen shot of the original l_employees table:

Thank you for any assistance you can provide :-)

Did you mean:

(credit_limit + 10.00) as new_credit_limit

the alias of the new column is new_credit_limit

and it consists of the value of credit_limit + 10.00 isn't it?

Thanks!! :-) This is the code that worked:

select l_employees.*,
first_name & ' ' & last_name as full_name,
(credit_limit + 10.00) as new_credit_limit
into sec0902_employees
from l_employees;