To fast to send .... You also get a potentially very long list of values not present in FILE_B so You'd want to have HUSH ON OFF around the second select.
--
Maybe ( at the cost of an extra sort - it's the .EXP that we want )
SELECT FILE_A BY.EXP RECORD_A SAVING RECORD_A SELECT FILE_B WITH NO @ID = "AA" "BB" "CC" SELECT.ONLY
or have I misunderstood the query or used somethg uv-specific?
-- mats
Aherne, John wrote:
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/
