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