merging multiple rows results in join statement

2002-11-07 Thread mysql
My last post wasn't titled accurately. Sorry for the repost. I have 3 tables. Ticket Pipeline_Dept, and Ticket_Matrix. Ticket_Matrix matches tickets to pipeline depts. A ticket can be posted to multiple pipeline depts. I want to select all tickets and the pipeline departments they are posted

Re: merging multiple rows results in join statement

2002-11-07 Thread Michael T. Babcock
[EMAIL PROTECTED] wrote: This is what I want: +--+--+ | ticketID | pipelineName | +--+--+ | 163 | IT, Adv.Tech, RD| | 164 | IT, RD | | 165 | Video, Multimedia| | ...