The Command that you are looking for is MERGE.LIST EG
SELECT FILE1 TO 1 SELECT FILE2 TO 2 MERGE.LIST 1 INTERSECT 2 TO 3 Rgds Bernard Lubin Bernard Lubin System Group Developer 549 Blackburn Rd Mount Waverley VIC 3149 Australia P: +61 3 9535 2222 F: +61 3 9535 2274 E: bernard.lu...@pentanasolutions.com W: pentanasolutions.com Pentana Solutions accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Bernard Lubin System Group Developer 549 Blackburn Rd Mount Waverley VIC 3149 Australia P: +61 3 9535 2222 F: +61 3 9535 2274 E: bernard.lu...@pentanasolutions.com W: pentanasolutions.com Pentana Solutions accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Anthonys Lists Sent: Tuesday, 4 March 2014 7:57 AM To: U2 Users List Subject: Re: [U2] Left Outer Join Question On 03/03/2014 19:06, randyleesmith wrote: > I've found that you can keep on going too as long as the keys are the same. > > > :SELECT FILE1 > xxx items selected. >> NSELECT FILE 2 > yyy items selected. >> NSELECT FILE 3 > zzz items selected. > > Turns out I may need to do it this way. > > Cool. > u2 neither knows nor cares how you get a select list, so each subsequent NSELECT doesn't know that the current list is the result of an NSELECT rather than a SELECT. The other way to do it is SELECT FILE1 TO 1 SELECT FILE2 TO 2 SELECT FILE3 TO 3 and then use commands that combine select lists. I can't remember what they are because I've never used them. Cheers, Wol _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Message protected by DealerGuard: e-mail anti-virus, anti-spam and content filtering. http://www.pentanasolutions.com Click here to report this message as spam: https://login.mailguard.com.au/report/1J6xBjB1pg/5xrs5L4i5SL8ElB4DyYMKj/1.507 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users