Business MySQL Select Statement to joint 2 fields value into 1 return June 24, 2019 You can use CONCAT to join 2 fields and return in 1 select statement value. e.g SELECT CONCAT(firstName,', ',lastName) as fullName FROM Read More »