×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
midrange.com
