Re: Using SQl to obtain a field value from one file or another

[Paul Therrien <paultherrien@xxxxxxxxxxxxxxxxxx>]

Are you saying that Field 2 in File 2 and Field 2 in file 3 are mutually
exclusive? 

Can you have the key value in file 1 be i both file 2 and file 3? 

If the key from file 1 exists in both file 2 and file 3 then what do you
expect to see in your result? 

Paul 

On 2017-06-30 13:50, Alan Shore wrote:

> Hi everyone
> Before I forget - we are on V7r1
> Happy 4th July weekend to the yanks
> I may be pushing my luck - Friday afternoon before what could be a 4 day weekend for many people
> But - here goes
> I will try and keep this as simple as possible
>
> I have 3 files
> File-1 has one field with values
> A
> B
> C
> D
> E
> Etc.
>
> File-2 contains 2 fields
> Field 1 contains an alpha character with SOME of the values that are in file-1
> Field 2 is just data
>
> File-3 also contains 2 fields
> Field 1 contains an alpha character with SOME of the values that are in file-1
> Field 2 is just data
>
> NOTE - the values A,B,C,D, E etc. will be in either File-2 or File-3 but NOT both
>
> How can I combine whats in file-1 with File-2 field 2 and File-3 field 2 but in ONLY 2 columns
> For example - this is what I am looking to produce from an SQL statement
>
> A             Field2 from File-2
> B             Field2 from File-2
> C             Field2 from File-3
> D             Field2 from File-3
> E              Field2 from File-2
>
> I tried the following
> Select File-1.Field1, File-2.Field2, File-3.Field2 from File-1 left join File-2 on
> File-1.Field1 = File-2.Field1
> left join File-3 on
> File-1.Field1 = File-3.Field1
>
> But that results in three columns - not 2
>
> As always - all responses gratefully accepted
>
> Alan Shore
> E-mail : ASHORE@xxxxxxxx
> Phone [O] : (631) 200-5019
> Phone [C] : (631) 880-8640
> 'If you're going through hell, keep going.'
> Winston Churchill