My 2 cents on this topic and maybe it'll trigger a UD/UV response. D3 allows you to GET-LIST A-LIST B-LIST and you get them combined for your next process.
Could this work for this person by pre-qualifying the 2 separate SELECT statements into 2 lists, blah. blah, blah. I'm interested to know as well. Thanks. ----- Original Message ----- From: "Bruce Lunt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 30, 2004 10:11 PM Subject: Re: Memo: RE: [UD] Union Query > Open mouth, ... insert foot. Or whatever :) > > I'm sorry, I spoke too quickly. The ID's are needed in the primary file. I > would copy all the ID's to a work file and then TRANS-ing the NAME.LO, to > ORDER and ORDER.CAN will work OK. Of course, if you do have the same ID in > both files you have to decide what do to do with that. > > Again, sorry for not testing out my solution before I offered it. > > Regards, > Bruce > > > > > > >From: "Allen Egerton" <[EMAIL PROTECTED]> > >Reply-To: U2 Users Discussion List <[EMAIL PROTECTED]> > >To: "U2 Users Discussion List" <[EMAIL PROTECTED]> > >Subject: Re: Memo: RE: [UD] Union Query > >Date: Fri, 30 Apr 2004 14:41:17 -0400 > > > > > >From: "Burwell, Edward" <[EMAIL PROTECTED]> > >To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]> > >Sent: Friday, April 30, 2004 2:00 PM > >Subject: RE: Memo: RE: [UD] Union Query > > > > > > > Does that work for you? It doesn't work for me. > > > > > > ORDER.FILE NAME..................... > > > > > > 114061 C.M.O.S. INC. *ASC* > > > 114062 AMERICAN PERFIT XSTAL > > > 122228 TIMELAND COMPANY > > > 122229 MCCANN ELECTRONICS *STR* > > > 130395 TERMINAL TECH SERVICE > > > 138562 TOWN VISION ELECTRONICS > > > 154897 CASIO SERV CENTER *ASC* > > > 163063 CASIO SERV CENTER *ASC* > > > 171230 AMERICAN PERFIT XSTAL > > > 195731 ELECT MUSIC INSTR *FAS* > > > 10 records listed > > > Enter <CR> to print non exist record ids > > > 007890 > > > 007891 > > > 007892 > > > 007893 > > > 007894 > > > 016057 > > > 016058 > > > 016059 > > > 016060 > > > 016061 > > > > > > Here is the dict: > > > > > > 001: I > > > 002: TRANS("ORDER.FILE",@ID,3,""):TRANS("ORDER.FILE.CAN",@ID,3,"") > > > 003: > > > 004: NAME > > > 005: 25L > > > 006: S > > > > > >I can't test it right now, I don't have access to a Universe machine until > >tonight. Try an ID.SUP, 'cause the ids for ORDER.FILE.CAN certainly > >aren't > >in ORDER.FILE. > > > >-- > >u2-users mailing list > >[EMAIL PROTECTED] > >http://www.oliver.com/mailman/listinfo/u2-users > > _________________________________________________________________ > MSN Toolbar provides one-click access to Hotmail from any Web page - FREE > download! http://toolbar.msn.com/go/onm00200413ave/direct/01/ > > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users