Re: [U2] Left Outer Join Question

George Gallen <[email protected]> Tue, 4 Mar 2014 09:00:45 -0600
Newsgroups gmane.comp.db.u2.general
Message-ID <7F929271DEA7CE48AE6DDCBC5C7283C42088CE13BA@DFW1MBX15.mex07a.mlsrvr.com>
Just to be sure, What does your VOC for MERGE.LIST show?

I'm on 10.0.2 of UV - but Information favor.

>ED VOC MERGE.LIST
4 lines long.

----: P
0001: V
0002: MERGE.LIST
0003: I
0004: GKSX

George

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of randyleesmith
Sent: Tuesday, March 04, 2014 7:39 AM
To: [email protected]
Subject: Re: [U2] Left Outer Join Question

I tried the simplest way and still could not get it to work.

SF-MORT>SELECT OLDMAS TO 1

5247 record(s) selected to SELECT list #1.
SF-MORT>SELECT TRWMONTHEND TO 2

5229 record(s) selected to SELECT list #2.
SF-MORT>MERGE.LIST 1 INTERSECT 2 TO 3

SELECT list 1 is not active.
SF-MORT>MERGE.LIST 1 INTERSECT 2

SELECT list 1 is not active.

I even tried the lowercase select and got the same result.

Our version is 10.2.7 and we are running in PICK PICK.FORMAT.
We are running a number of older applications and Proc's.
So it may because of the Version I'm using.

----:
0001: X
----:
0002: 10.2.7
----:
0003: PICK
----:
0004: PICK.FORMAT
----:
0005: 10.2.7



-----
I used to be an Optimist until I knocked over the glass.
--
View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42772.html
Sent from the U2 - Users mailing list archive at Nabble.com.
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users