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