RE: Define a Join over two files with same field names

Are only the join field named identically or also other fields?
If it is only the join fields, you may use the following statement:

Select KeyField1, KeyField2, ... KeyField N, a.*, b.*
From File1 a join File2 b using (KeyField1, KeyField2, ... KeyField N);

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 <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Raul
Jager
Sent: Dienstag, 17. September 2019 17:59
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Re: Define a Join over two files with same field names

CREATE View r37files/orderhead43

AS SELECT * from wkvcohead

UNION ALL

SELECT * from vcohead

On 9/17/19 11:27 AM, Art Tostaine, Jr. wrote:

I have two order header files that are identical. One is posted
orders and one is unposted.

I want to join them so I can read both. I need to see the invoice#
(OAINV) from both files.

I tried this but received error that column list required. Is this
possible? Thank you

CREATE VIEW r37files/ordhed43
AS SELECT u.oaord, p.oaord, u.oarev#, p.oarev# FROM wkvcohead u,
vcohead p WHERE u.oacmp = p.oacmp
and u.oaord = p.oard

-- Este e-mail fue enviado desde el Mail Server del diario ABC Color --
-- Verificado por Anti-Virus Corporativo Symantec --