Re: SQL , multi row note file.

["Raul A. Jager W." <raul@xxxxxxxxxx>]

If you want to present the list in a browser, NetData will do what you 
need very easily.

Hatzenbeler, Tim wrote:

> A couple of corrections...
> Po456,I'm green,1
> Should be:
> Po456,color: green,1
>
> And
> Po456,fred,color: green
> Should be
> Po456,fred,fargo
>
> Sorry for my typos.
>
> Thanks, Tim
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Hatzenbeler, Tim
> Sent: Wednesday, May 28, 2008 4:30 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: SQL , multi row note file.
>
> I this possible?
>
> I have a "note" table, that may or may not have data.
>
> For example.
>
> Po#,note_txt,note_seq#.
> ----------------------------
>
> Po123,this item is red and,1
> Po123,has pink dots,2
> Po123,please only order on christmas,3
> Po456,I'm green,1
>
> Po table
> -------------
> Po#,customer,address
> Po123,tim,Spokane
> Po456,fred,color: green
>
> I would like a query that would show me,
>
> Po123,tim,Spokane,this item is red and has pink dots please only order on Christmas.
> Po456,fred,fargo,color: green
>
>
> Is that at all possible?
>
> Thanks, Tim
>
>
>
> Think Green! Please do not print this e-mail unless you need to. Thank you.
>
>
> ------------------------------------------------------------------------------
> This e-mail message, including any attachments, is for the
> sole use of the intended recipient(s) and may contain
> confidential or privileged information.  Any unauthorized
> review, use, disclosure or distribution is prohibited. If
> you are not the intended recipient, please contact the
> sender by reply e-mail and destroy the message.
>
>
> ==============================================================================
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
>
> ------------------------------------------------------------------------------
> This e-mail message, including any attachments, is for the
> sole use of the intended recipient(s) and may contain
> confidential or privileged information.  Any unauthorized
> review, use, disclosure or distribution is prohibited. If
> you are not the intended recipient, please contact the
> sender by reply e-mail and destroy the message.
>
>
> ==============================================================================
>
>
>
> ------------------------------------------------------------------------------
> This e-mail message, including any attachments, is for the
> sole use of the intended recipient(s) and may contain 
> confidential or privileged information.  Any unauthorized
> review, use, disclosure or distribution is prohibited. If
> you are not the intended recipient, please contact the 
> sender by reply e-mail and destroy the message.
>
>
> ==============================================================================
>
>