join first name and last name sql code example Example: join first name and last name sql SELECT CONCAT(first_name , ' ', last_name) as Name from TableName