Re: A complex sql issue

[Joe Pluta <lists@xxxxxxxxxxxxxxxxx>]

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