Re: [U2] Left Outer Join Question
Will Johnson <[email protected]> Tue, 4 Mar 2014 09:19:08 -0800 (PST)
| Newsgroups | gmane.comp.db.u2.general |
|---|---|
| Message-ID | <[email protected]> |
SELECT OLDMAS 5247 records selected NSELECT TRWMONTHEND -----Original Message----- From: randyleesmith [via U2 (UniVerse & UniData)] <[email protected]> To: Will Johnson <[email protected]> Sent: Tue, Mar 4, 2014 4:39 am Subject: Re: 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. If you reply to this email, your message will be added to the discussion below: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42772.html To start a new topic under U2 - Users, email [email protected] To unsubscribe from U2 (UniVerse & UniData), click here. NAML -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42775.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