>>Here’s another one... I have two tables, one has a name Foreign Key, the other the names. I would like to create a third table via SQL SELECT that would have a field
“Full Name” that would have the combined fields FirstName and LastName looking something like
LastName, Firstname. Is this something I can do somewhat easily in SQL?
>
>Something like
>
>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
Thanks, that's pretty simple.
Jim Philippi
quando omni flunkus moritati