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:* randyleesm...@roadrunner.com
*To:* u2-users@listserver.u2ug.org
*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
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to