I think if you look up old posts on LSELECT, you may find an acceptable answer. It is a program that creates and uses work files, but once written, it works like a verb. I got it from the list and now use it regularly.... Cheers, Kebbon
> From: ggal...@wyanokegroup.com > To: u2-users@listserver.u2ug.org > Date: Tue, 9 Aug 2011 16:15:23 -0500 > Subject: Re: [U2] Can this Selection be done? Either UV or SQL? > > I found something about this on an old U2ug post from a few years ago. > > -------------------------------------------------------------------- > I do it in a similar way... > > SELECT @ID FROM EINVOICES WHERE iInvoiceRef IN (SELECT EVAL "@RECORD" > FROM &SAVEDLISTS& 'INV.REF.LIST'); > > ... But I agree there should be a more "natural" way of doing this. > > Perry Taylor > --------------------------------------------------------------------- > > > -----Original Message----- > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > boun...@listserver.u2ug.org] On Behalf Of George Gallen > > Sent: Tuesday, August 09, 2011 12:43 PM > > To: U2 Users List > > Subject: Re: [U2] Can this Selection be done? Either UV or SQL? > > > > Is there anyway to : > > > > SELECT ID FROM CUSTOMERS WHERE CITY IN (GETLIST LISTNAME); > > > > To avoid having to put the list into a scratch file > > > > George > > > > > -----Original Message----- > > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > > boun...@listserver.u2ug.org] On Behalf Of Holt, Jake > > > Sent: Tuesday, August 09, 2011 12:29 PM > > > To: U2 Users List > > > Subject: Re: [U2] Can this Selection be done? Either UV or SQL? > > > > > > You can use IN > > > > > > SELECT id from customers where city IN (select cityname from cities > > > where state='MN'); > > > > > > > > > > > > -----Original Message----- > > > From: u2-users-boun...@listserver.u2ug.org > > > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George > > > Gallen > > > Sent: Tuesday, August 09, 2011 11:09 AM > > > To: U2 Users List > > > Subject: [U2] Can this Selection be done? Either UV or SQL? > > > > > > ok. I have a select list of values. > > > > > > Is there a way to select a file and return all ID's that contain an > > > item > > > with a field that matches one of the values in a select list? > > > > > > At least from the command line, and not have to write a program. > > > > > > > > > George Gallen > > > Senior Programmer/Analyst > > > Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com > > > ph:856.848.9005 Ext 220 > > > The Wyanoke Group > > > http://www.wyanokegroup.com > > > > > > > > > > > > _______________________________________________ > > > U2-Users mailing list > > > U2-Users@listserver.u2ug.org > > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > _______________________________________________ > > > U2-Users mailing list > > > U2-Users@listserver.u2ug.org > > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users