SQL
Building a string of subquery results in SQL
We have a table which includes a one-to-many relationship with some second table. Perhaps a person table which has a relationship to different email addresses associated with that person We want to build a query to return the person's name and the email addresses as a comma separated