select and join lastname to first_name sql code example

Example: join first name and last name sql

SELECT CONCAT(first_name , ' ', last_name) as Name from TableName