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
