Nick,

>select table1.employee_id, ;
>ALLTRIM(employee.first_name) + " " + ALLTRIM(employee.last_name) AS FULL_NAME ;
>FROM table1, employee
>WHERE table1.employee_id = employee.employee_id ;
>INTO table3

Better PADR that expression, or you'll lose info if the first item has short first and/or last name.