>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