My take on it was that he had 3 save-lists and he wanted to select from FILE_A those items that were not in any of the lists. NSELECT maybe but perhaps not.
----- Original Message ----- From: "Allen E. Elwood" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, April 12, 2005 2:02 PM Subject: RE: [U2] Complicated Select > No, it's not just you. I read it three times and still am amazed that the > syntax was even allowed. I have never seen anyone use more than one file in > a select list in 17 years of using pick out of my 31 years of programming... > Live and learn! > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] > Sent: Tuesday, April 12, 2005 10:05 > To: [email protected] > Subject: Re: [U2] Complicated Select > > > Maybe it's just me, but I read your email multiple times and don't really > know what you are asking. > > Are you saying you have two files FILE_A and FILE_B and a select list of > IDs you wish to omit? > > In other words, select all records in FILE_A that have the same item ID in > FILE_B and then MERGE-LIST DIFF with the omit list? > > Bruce M Neylon > Health Care Management Group > > > > > > "Aherne, John" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 04/11/2005 07:04 PM > Please respond to u2-users > > > To: <[email protected]> > cc: > Subject: [U2] Complicated Select > > Hi all, > I want to do a complicated select statement in UD. > Basically, I > have a list of items "AA", "BB", "CC". I want to do a select along these > lines: > > SELECT FILE_A WITH RECORD_A IN (SELECT FILE_B WITH NO @ID = "AA" "BB" > "CC") > > RECORD_A is MV > > > Is there a way to do this in UD? > > TIA, > John Aherne > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
