SELECT merging several columns from one table
Posted: Wed Mar 07, 2007 5:53 am
I have a query
what I really like is for the fields "add1, add2, town, county, postcode" to be formatted with comma and space and in the result as one field say "address".
How do I do that?
Code: Select all
SELECT surname,addressname,children, add1,add2,town,county,postcode,phone,mobile,email,email2 FROM address ORDER BY surnameHow do I do that?