The LSELECT is actually from IBM/Rocket and can be found here:
https://u2devzone.rocketsoftware.com/accelerate/articles/u2-select/u2-select
kebbon.irwin wrote:
>
>
> 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
-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.
>
>
&g
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
ke
> 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');
>
>
>
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 Use