W3School TIY Editor

SELECT CustomerName, Address & ", " & PostalCode & ", " & City AS Address FROM Customers;