I could write a subr to fetch these, but I don't know how to do it with uniquery only. I think Noah is saying that he wants to... SELECT all File2 items if FILE1_ID can be found in the savedlist containing the IDs from File1.
In this case, won't BLAH still contain IDs from File1? > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jim Bullock > Sent: Monday, July 25, 2005 10: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/