[EMAIL PROTECTED] wrote:
This is what I want: +----------+--------------------------+ | ticketID | pipelineName | +----------+--------------------------+ | 163 | IT, Adv.Tech, R&D | | 164 | IT, R&D | | 165 | Video, Multimedia | | ... | ... | +----------+--------------------------+This is an output / formatting issue; you'll either have to do it externally (which you said you can't), use a string concat function (not sure if that'll work or not; never done it in SQL), or do two queries;
SELECT ticketID .... LIMIT 10;
SELECT pipelineName ... WHERE ticketID IN (previous response list);
... then format your output accordingly.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
