[Solved] Simple SQL concatenation

You use:

SELECT Tablename, CONCAT(fieldName1,', ',fieldName2,', ',fieldName3) AS name FROM Tablename;