Re: SQL joining question

["Dare" <oludare@xxxxxxxxxxxxx>]

Can someone address the RDB design of these files?  What NORMAL FORM is
this?

Dare

----- Original Message -----
From: "Rolf Mittag" <mailing-lists@r-m-e-d-v.de>
To: <rpg400-l@midrange.com>
Sent: Tuesday, December 18, 2001 9:52 AM
Subject: RE: SQL joining question


> this is a union of 2 joins
>
> select a.custno as cstnum, ... from File1 a join File2 b on a.custno =
> b.custno
>
> union
>
> select a.custno as cstnum, ... from File2 a join File1 b on a.custno =
> b.custno
>
> order by cstnum
>
> hth Rolf
>
> ~~~~~~~~~~~~~~~~~~~~~
> Dipl.Inf.(FH) Rolf P Mittag
> IBM Partner in Development
> Leipziger Str. 50
> D-69214 Eppelheim
> Fon: +49 (6221) 76 78 60
> Fax: +49 (6221) 76 80 26
> eMl: rm@r-m-e-d-v.de
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>