Re: SQL join question

[Booth Martin <booth@xxxxxxxxxxxx>]

ah, so simple with primary/secondary files and matching records....



rick baird wrote:
> I have two identical files, keyed uniquely by the same fields.
>
> the first will have records that may or may not exist in the second
> and the second will also contain records that may or may not exist in
> the first.
>
> I need an sql select statement (or DDS join if that's my only option)
> that will pair these records side by side, showing all records in both
> files, like this:
>
> contents of file1
>
> key1 description1
> a    description
> b    description
> c    description
> d    description
> e    description
>
> contents of file2
>
> key2 description2
> c    description
> d    description
> e    description
> f    description
> g    description
>
> result of select - join
>
> key1 description1    key2 description2
> a    description     -    -
> b    description     -    -
> c    description     c    description
> d    description     d    description
> e    description     e    description
> -    -               f    description
> -    -               g    description
>
> a left outer join will not include the f or g records in the second
> file, and an exception join won't show the c,d,e records in either
> file.
>
> what's a mother to do?
>
> thanks,
>
> Rick