>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
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison