Yes, see followup message -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Monday, July 25, 2005 9:41 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Select on an attribute
I thought you wanted a list of File2 IDs. Won't the MERGE.LIST INTERSECTION give you a list of File1 IDs? > Great! That is exactly what I needed. > > I forgot about the INTERSECTION option. > > Noah > > -----Original Message----- > (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. > "...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 (Hmm. I'd swear I've heard either him or his buddies say "you can't legislate morality".) ------- 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/