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, R&D| | 164 | IT, R&D | | 165 | Video, Multimedia| | ..

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 pos