Actually, that looks like an attempt to adapt an SQL syntax. That type of logic is common in SQL statements
Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. "The more they complicate the plumbing the easier it is to stop up the drain" - Montgomery Scott NCC-1701 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Tuesday, April 12, 2005 2:02 PM To: [email protected] 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/
