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/

Reply via email to