Re: Use SQL to give me one record from many

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Alan,

As Rob said, it seems a work for pivot tables. Also, I'm quite busy at this
moment, but you can find an article and utility for pivot tables here:

http://www.itjungle.com/mpo/mpo032703-story01.html

HTH,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Tue, Jun 7, 2011 at 1:35 PM, <rob@xxxxxxxxx> wrote:

> Busy, but I think what you are looking for is called a "pivot table".
>
>
> Rob Berendt
> --
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>          Garrett, IN 46738
> Ship to:  Dock 108
>          6928N 400E
>          Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:   Alan Shore <ashore@xxxxxxxx>
> To:     "'midrange-l@xxxxxxxxxxxx'" <midrange-l@xxxxxxxxxxxx>
> Date:   06/07/2011 01:58 PM
> Subject:        Use SQL to give me one record from many
> Sent by:        midrange-l-bounces@xxxxxxxxxxxx
>
>
>
> Hi everyone
> Here is my predicament
> I have one file with 2 fields, for example
> Field 1                  Field 2
> A                            100
> A                            150
> A                            161
> B                            007
> C                            005
> C                            001
> C                            017
> C                            999
> Etc.
> I need to provide the following result in a different file
> Field 1                  Field 2                  Field 3 Field 4 etc.
> A                            100                       150       161
> B                            007
> C                            001                       005       017
> 999
> And so on
> I am sure that I have seen some e-mails about this in the past, and I have
> tried looking for them, but I am not even too sure what the correct key
> words should be
> So - if anyone can point me in the correct direction, as always, all
> responses MUCH appreciated
>
> Alan Shore
> Programmer/Analyst, Direct Response
> E:AShore@xxxxxxxx
> P:(631) 200-5019
> C:(631) 880-8640
> "If you're going through Hell, keep going" - Winston Churchill
>
> --
> 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 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.