I don't get it either.  The example looks like a mix of sql & mv select
syntaxes (syntaci?)
If you can clarify, I'll bet the answer is yes, there is a good way to
do it with UniQuery.

-----Original Message-----
From: [EMAIL PROTECTED]

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?


"Aherne, John" <[EMAIL PROTECTED]>

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/

Reply via email to