Hi,
You can try the following.
Store the result of your query into a temporary table, say tp, with two
columns tc (ticketID) and pname (pipelineName).
Run the following query :
select concat("select @c:='';","select tc,
(@c:=concat_ws("","",@c,pname)) as x, length(@c) from tp where tc=",
tc," o
Hi all.
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 to but only one row per ticket. So:
SELECT