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

You have to use column aliase because then names in the resulting view
must be unique


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

Greetings,

Franz






From: "Art Tostaine, Jr." <atostaine@xxxxxxxxx>
To: "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxxxxxxxx>
Date: 17.09.2019 17:27
Subject: Define a Join over two files with same field names
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx>



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