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

Sorry, I was too fast before!

May be I misunderstand what you need, ... but what about:
Joining File 1 with File 2 (inner join - returns only rows found in both
tables) Joining File 1 with File 3 (inner join) And then merging the result
of both sub-selects?

Something like this:

Select *
from ( Select aCol1, bCol2
from TableA join TableB on aCol1 = bCol1
Union
Select aCol1, cCol2
From TableA join TableC on aCol1 = cCol1) x (Col1, Col2)
Order By Col1

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob
Berendt
Sent: Freitag, 30. Juni 2017 20:05
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Using SQl to obtain a field value from one file or another

Paul
<snip>
NOTE - the values A,B,C,D, E etc. will be in either File-2 or File-3 but NOT
both </snip>


Rob Berendt