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: u2-users@listserver.u2ug.org 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: <u2-users@listserver.u2ug.org> 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 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/