Concatenate results of subquery in select

Yes, I know this is not standard practice but, I am working on a report and I would like all of the buildings this teacher teaches at to be in a single CF query column. I hope to get query results like: TeacherName Buildings Bob High School, Middle School, EMC Sue

RE: Concatenate results of subquery in select

Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] ia.net] Sent: 18 July 2003 16:27 To: CF-Talk Subject: Concatenate results of subquery in select Yes, I know this is not standard practice but, I am working on a report and I would like all of the buildings this teacher teaches

Re: Concatenate results of subquery in select

Mark W. Breneman wrote: I hope to get query results like: TeacherName Buildings Bob High School, Middle School, EMC Sue ELC, Middle School Here is basically what I am trying to do: SELECT TeacherName, (select buildingname from location