Thanks Shawn, You have pin pointed the problem. I replied earlier to Jim that it would work, but of course you are right, I need the FILE2 IDs, not the FILE1 IDs
Noah -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Waldie Sent: Monday, July 25, 2005 9:07 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Select on an attribute 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/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
