Re: [U2] Left Outer Join Question

If you on UniData and you're in PICK mode then you have to lower case 
this kind of thing, since such PRIME style stuff only works in the 
UniData parser mode.  So, try this:

3 Dev (0)-> SELECT ADDRBOOK WITH MAILLIST NE "" AND WITH MAILLIST_OWNERS 
= "[BOD]"

309 records selected to list 0.

SAVE-LIST BILL1
Overwriting existing saved list.
309 key(s) saved to 1 record(s).
SELECT ADDRBOOK WITH CUSTOMERS NE ""

114 records selected to list 0.

SAVE-LIST BILL2
114 key(s) saved to 1 record(s).
get.list BILL1 TO 1
309 records retrieved to list 1.
get.list BILL2 TO 2
114 records retrieved to list 2.
merge.list 1 UNION 2 TO 0
423 record(s) selected.
3 Dev (0)>>

...and here we are with 423 items selected as the active select list.

HTH,

Bill

------------------------------------------------------------------------
//----- Original Message -----
*From:* [email protected]
*To:* [email protected]
*Date:* 3/3/2014 2:36 PM
*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

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