Re: [U2] Left Outer Join Question

"Baakkonen, Rodney A (Rod) 46K" <[email protected]> Mon, 3 Mar 2014 17:41:08 -0500
Newsgroups gmane.comp.db.u2.general
Message-ID <238F67A5ADD8DE4192D3A3647FCF0E6C01BAC080AD@wdce7m017.internal.cigna.com>
What ECl type are you using. If you are using 'P' instead of 'U', use the lowercase verb and it should work

select FILE1 TO 1 
select FILE2 TO 2
MERGE.LIST 1 INTERSECT 2 TO 3 


-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of randyleesmith
Sent: Monday, March 03, 2014 4:37 PM
To: [email protected]
Subject: Re: [U2] Left Outer Join Question

I must be doing something wrong.

When I try this I get;

SELECT FILE1 TO 1 
SELECT FILE2 TO 2 
MERGE.LIST 1 INTERSECT 2 TO 3 

SELECT list 1 is not active.




-----
I used to be an Optimist until I knocked over the glass.
--
View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42762.html
Sent from the U2 - Users mailing list archive at Nabble.com.
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users

------------------------------------------------------------------------------
CONFIDENTIALITY NOTICE: If you have received this email in error,
please immediately notify the sender by e-mail at the address shown. 
This email transmission may contain confidential information.  This
information is intended only for the use of the individual(s) or entity to
whom it is intended even if addressed incorrectly.  Please delete it from
your files if you are not the intended recipient.  Thank you for your
compliance.  Copyright (c) 2014 Cigna
==============================================================================

_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users