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/