Re: [U2] Left Outer Join Question

Also keep in mind that MERGE.LIST (if you can get it to work) will also
Remove Duplicate Keys

George

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Bill Haskett
Sent: Tuesday, March 04, 2014 2:22 PM
To: U2 Users List
Subject: Re: [U2] Left Outer Join Question

NSELECT gets the items in the list, created by "SELECT X", that do not 
exist in Y.  Consequently, you can do things like:

SELECT VENDORS WITH LAST USED > "01/01/13" INVOICEKEY
xxx records selected to list 0
NSELECT INVOICES

...where INVOICEKEY is the field that produces the record keys into the 
INVOICES file.

Duplicate keys are a different story.  If you want the list to be 
duplicate free then you need to use the "SAVING UNIQUE" (that's UniData 
but I think it's also UniVerse) keyword at the end of the SELECT 
statement.  e.g.

SELECT VENDORS WITH LAST USED > "01/01/13" INVOICEKEY
xxx records selected to list 0
SELECT INVOICES SAVING UNIQUE @ID

HTH,

Bill

------------------------------------------------------------------------
----- Original Message -----
*From:* [email protected]
*To:* [email protected]
*Date:* 3/4/2014 11:07 AM
*Subject:* Re: [U2] Left Outer Join Question
> If I do;
>
> SELECT X
> NSELECT Y
>
> Won't that take all my duplicate keys out from Y when I only want selected
> ones taken out from Y?
>
_______________________________________________
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