Re: A complex sql issue

[Rpglist <rpglist@xxxxxxxxxxx>]

Thanks joe 

Sent from my iPhone

On Dec 28, 2012, at 11:18 AM, Joe Pluta <lists@xxxxxxxxxxxxxxxxx> wrote:

> On 12/28/2012 10:16 AM, Alan Shore wrote:
> > where a.Fld1 = b.Fld1 and
> >       a.Fld2 = b.Fld2 and
> >       a.Fld3 = b.Fld3 and
> >       a.Fld4 = b.Fld4 and
> >       a.Fld8 = b.Fld8 and
> >       a.Fld9 = b.Fld9 and
> >       a.Fld10 = b.Fld10
>
> Just as a note, DB2 has had this syntax for a while:
>
> where (a.fld1, a.fld2, a.fld3, a.fld4, a.fld8, a.fld9, a.fld10)
>     = (b.fld1, b.fld2, b.fld3, b.fld4, b.fld8, b.fld9, b.fld10)
>
> Joe
> -- 
> 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.