You can use CONCAT to join 2 fields and return in 1 select statement value.

e.g

SELECT CONCAT(firstName,', ',lastName) as fullName FROM tableName