Great! That is exactly what I needed. I forgot about the INTERSECTION option.
Noah -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Bullock Sent: Monday, July 25, 2005 8:18 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UD] Select on an attribute (If "BLORP" is your savedlist from File1) GET.LIST BLORP TO 1 SELECT FILE2 SAVING FILE1_ID TO 2 MERGE.LIST 1 INTERSECTION 2 TO 3 SAVE.LIST BLAH FROM 3 "BLAH" will contain the IDs you want, if I understand your question correctly.) --- Noah Hart <[EMAIL PROTECTED]> wrote: > Select question: > > Assume that I have 2 files, such as customer and invoice > > File1: has 1 attribute, ID > File2: has 2 attributes, ID and FILE1_ID > > I have a savedlist with ID numbers from file1. > > I want to select all records in file2 which have FILE1_ID matching the > savedlist I already have. > > Is this possible? > > Thank you, > > Noah > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > "...a livable wage is a moral value. Affordable health care is a moral value. A decent education is a moral value. A common sense foreign policy is a moral value. A healthy environment is a moral value. The feeling of community that comes from full participation in our democracy is a moral value. It is a moral value to make sure that we do not saddle our children and grandchildren with our debt." -Howard Dean __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/