I have a database table that contains a list of contacts, some of those contacts might have multiple records, e.g.
CustomerID, CustomerName, Vehicle
1, Dan, Mazda
1, Dan, Suzuki
2, John, Ford
3, Dasha, Volvo
3, Dasha, Ford
Can I write a select query to return the distinct customerID and CustomerName, and a list of vehicles in 1 record? i.e.
1, Dan, Mazda+Suzuki
2, John, Ford
3, Dasha, Volvo+Ford
Thanks