You can use CONCAT to join 2 fields and return in 1 select statement value. e.g SELECT CONCAT(firstName,’, ‘,lastName) as

Read More